reality Posted November 29, 2023 Report Posted November 29, 2023 49 minutes ago, Android_Halwa said: Certainly! To achieve this in Excel, you can use the COUNTIFS function. Assuming your data is in columns A and B, and the dates are in rows 1 and 2, you can enter the following formulas: For the count of Apples on 11/16/2023: ```excel =COUNTIFS($A$1:$A$5,"11/16/2023",$B$1:$B$5,"Apple") ``` For the count of Mangos on 11/16/2023: ```excel =COUNTIFS($A$1:$A$5,"11/16/2023",$B$1:$B$5,"Mango") ``` Repeat the process for 11/18/2023. Your Excel sheet should look like this: ``` A B 1 11/16/2023 11/18/2023 2 2 1 (Apple) 3 0 2 (Mango) ``` You can adjust the ranges and cell references based on your actual data structure. Let me know if you need further clarification! ni post chusinanka ee demo gurthochindhi… https://www.instagram.com/reel/Cz9OnlNgZl5/ 1 Quote
Android_Halwa Posted November 30, 2023 Report Posted November 30, 2023 32 minutes ago, kittaya said: Super Mava... ide anukunta unna... ela cheyyalo ardm kalaaa Thanks Thanks to ChatGPT…. 1 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.