Jump to content

excel gurus Help needed


Recommended Posts

Posted
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/

  • Thanks 1
Posted
32 minutes ago, kittaya said:

Super Mava... ide anukunta unna... ela cheyyalo ardm kalaaa 

Thanks 

Thanks to ChatGPT….

  • Thanks 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...