Forum Discussion
Need help with SUMIF Formula
Hello, I am trying to use a SUMIF formula to show me if an item has been completed. Please see the picture added. The highlighted are where I am trying to have the formula in. Please see the ...
=SUMPRODUCT(($D$2:$D$15<>"")*(($B$2:$B$15="group 1")+($B$2:$B$15="group 2")+($B$2:$B$15="group 3"))*($C$2:$C$15=D18))You can try SUMPRODUCT.
Thanks for the reply! Not all non-completes are going to be blanks though which is why I had a few N/As in there