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....
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....
