Excel Q&A
Ask your geeky hard core Excel questions here!
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Ask your geeky hard core Excel questions here!
What am I doing wrong with this formula it keeps returning “0”?
=SUMIF(A7:A21,"MONTH(3)",C7:C21)
Notes:
A7:A21 are dates in this format (3/5)
Condition is to see if the Month is March (thus I use 3)
C7:C21 is the sale amount to add if condition is true
I also tried the following and it also returns 0
=SUMIF(A7:A21,"=” &MONTH(3)",C7:C21) Read More