Hi Guys
EID Mubarak could anyone help out with the solution i have a formula with sumifs to sum Hours based on multiple criteria, after dragging formula down i need where nothing to show blank rather than showing zero in cell
I'd like the sum to return results where one part of the criteria is blank - to return blank cell rather having zero is this possible? Thank you.
[=SUMIFS($L$18:$L$20,$I$18:$I$20,Z$17,$D$18:$D$20,$V18,$C$18:$C$20,$X18,$B$18:$B$20,$B$9)]
EID Mubarak could anyone help out with the solution i have a formula with sumifs to sum Hours based on multiple criteria, after dragging formula down i need where nothing to show blank rather than showing zero in cell
I'd like the sum to return results where one part of the criteria is blank - to return blank cell rather having zero is this possible? Thank you.
[=SUMIFS($L$18:$L$20,$I$18:$I$20,Z$17,$D$18:$D$20,$V18,$C$18:$C$20,$X18,$B$18:$B$20,$B$9)]