How write blank cells as the criteria "URGENT"

L

LIZZIE

I have learned how to count cells with data according to criteria, bu
now part of my criteria is cells that are empty and I don't know how t
write.

{=SUM((D1:D81="0_F")*(J1:J81="I"))}

In the illustration above I need to count the cells that are blank i
Column D AND I in Column J

I thought this is how I would write it, but it doesn't work.

{=SUM((D1:D81=" ")*(J1:J81="I"))}


Thanks for any help
 
P

Peo Sjoblom

If you look for " " that is a space and not a blank cell.
Don't know why anyone would enter a space in a cell?
If it is done because there used to be something else, use delete
instead of pressing the space bar

Use "" instead of " " in your formula
 
Top