count blank with multiple conditions
Posted by Kathi on May 11, 2001 4:20 AM
I need to count an empty cell in one column when it occurs in conjunction with 2 seperate conditions in two different columns. Example: Row A contains the potentially blank cell. I need to count that cell when "toys" occurs in the same row and in column B and also when "boys" occurs in the same row and column C. I hope I have made this clear. PLEASE help on this, as I am almost blind now from peering at my laptop screen in vain.