Forum Discussion
Solved
SUMIFS IS GIVING ZERO VALUES
Team can I get some insights as to the SUMIFS is giving zero value .
Here is an image of the excel I'm working in.
- your formula is wrong. but you didn't include what you used so hard to say what.
you could have dates that are text (even though text looks like a date doesn't mean excel recognizes it as a date)
you could be comparing a year value to a date value (only = if it is 1/1/YYYY)
you could have format errors in the SUMIFS formula
other....
- your formula is wrong. but you didn't include what you used so hard to say what.
you could have dates that are text (even though text looks like a date doesn't mean excel recognizes it as a date)
you could be comparing a year value to a date value (only = if it is 1/1/YYYY)
you could have format errors in the SUMIFS formula
other....
