Hi, I have this question please
Column :
C5:C100 is date Format like 06/09/2020
D5:D100 is Numerical
F5:F100 is General
A1=Name1
A2= September
I need to SUM D5:D100 IF C5:C100=A2 and F5:F100=Name1
Thanks
Hi, I have this question please
Column :
C5:C100 is date Format like 06/09/2020
D5:D100 is Numerical
F5:F100 is General
A1=Name1
A2= September
I need to SUM D5:D100 IF C5:C100=A2 and F5:F100=Name1
Thanks
Take a look at using sumifS()
=SUMifs(D5:D100,C5:C100,A2,F5:F100,Name1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, but date is format is defined like 06/07/2020 and in A2 month is ...like September !
You can use this in the formula:
=MONTH(DATEVALUE(A2&" 1"))
This will convert the name to a month number that you can then use to construct dates for the start and end of the month to then use as bigger than or less than or equal to criteria in the SUMIFS.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If that doesnt work for you, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Maybe like this
=SUMPRODUCT($D$5:$D$100,(TEXT($C$5:$C$100,"mmmm")=$A$2)*($F$5:$F$100=$A$1))
Happy to help and thanks for the feedback
What feedback? Has this been solved?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. .
I got a "very good" and rep'd for this (at 8:31 pm), Ali, so I guess they got what they wanted - maybe from Phuocam??
Ah, OK. Obviously my suggestion didn’t help, then.
Didnt look like mine did either
No, which is why confusion reigns. I do wish established members would remember to add the SOLVED tag when they are done.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks