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
81="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
81=" ")*(J1:J81="I"))}
Thanks for any help
now part of my criteria is cells that are empty and I don't know how t
write.
{=SUM((D1

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

Thanks for any help