Hello,
I need some help with counting blank cells.
Here's my data:
Name Feb 07
Roger x
Lisa
Bob x
Lisa
Lisa x
Lisa
Lisa x
Bob
Bob x
Bob
Roger x
Bob x
Roger
I need a formula that will count the blank cells in Feb 07 column if the Name column =Roger. Something like if(Name="Roger", countblank(Feb 07)). Please help.
Thanks