seriousdamage
Board Regular
- Joined
- Aug 14, 2005
- Messages
- 58
Hello,
I use a SUMIFS formula to sum various lines in a data file by choosing multiple criteria like Month, Quarter and Year
However there are situations where I don't need to select all 3 criteria, but only want the year, in this case the formula returns a value of zero.
How can I get around this?
Many Thanks
Nic
I use a SUMIFS formula to sum various lines in a data file by choosing multiple criteria like Month, Quarter and Year
However there are situations where I don't need to select all 3 criteria, but only want the year, in this case the formula returns a value of zero.
How can I get around this?
Many Thanks
Nic