hi,
im trying to use sumproduct for counting instances based on two criteria conditions. however while calculating, the formula even considers blank cells in the count. is there any way that excel does not considers blank cells while counting. Have attached a sample file for example.
plz help.
Bookmarks