Forum Discussion
Sumif formula need help
Hi, The below formula is what I am using to individually calculate the data based on the year and months selected from the dropdown. Please advise what should I add to get the overall sum if I select...
In general criteria to calculate all non-blank is "<>". Thus it could be like
=COUNTIFS(<range>,IF($C$17="All","<>",$C$17),<range2>,...)
How it'll be in your concrete case it's bit hard to say without knowing which data do you have in columns M and N, where are your C14 and C17, etc.