How write blank cells as the criteria "URGENT"

  • Thread starter Thread starter LIZZIE
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top