Hello,
I need a formula to sum up column D only where there are no blank cells in column F
I attached a file for example with the formula in C12-C15 , but the formula does not work.
Can you please assist?
Thank you.
Hello,
I need a formula to sum up column D only where there are no blank cells in column F
I attached a file for example with the formula in C12-C15 , but the formula does not work.
Can you please assist?
Thank you.
It's better to enter the expected results than a formula that 'doesn't work', that way we can see clearly what you want, not what you've tried.
Try
=SUMIFS($D$2:$D$7,$C$2:$C$7,$B12,$F$2:$F$7,">0")
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks