jmaivang
Jun 21, 2007, 02:42 PM
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
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