I am trying a sumproduct formula
=SUMPRODUCT((C4:C5000=A4)*(L4:L5000="COOKED")*(H4:H5000))
I GET A DIV/0 ERROR IN THE CELL
Any help would be great.
thank you
Josh
I am trying a sumproduct formula
=SUMPRODUCT((C4:C5000=A4)*(L4:L5000="COOKED")*(H4:H5000))
I GET A DIV/0 ERROR IN THE CELL
Any help would be great.
thank you
Josh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks