I'm trying to sum values between two dates. and using formula:
=SUMIFS(D12:EF12,$D$9:$EF$9,">="&C$5,D12:EF12,"<="&C$6). but in this formula blank cells count as zeroes. this distract my other formulas. how can i exclude blank cells in this summing.
=SUMIFS(D12:EF12,$D$9:$EF$9,">="&C$5,D12:EF12,"<="&C$6). but in this formula blank cells count as zeroes. this distract my other formulas. how can i exclude blank cells in this summing.