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

All I could come up with si using the dcount and subtracting the count


Name Feb 07
Roger x
Lisa
Bob x
Lisa
Lisa x
Lisa
Lisa x
Bob
Bob x
Bob
Roger x
Bob x
Roger


=COUNTIF(Name,"Roger")-DCOUNTA(data,2,K13:K14)
The Dcount function refers to a database(including headings), 2 is the second column in the databse, K13 is Name and K14 is Roger

Hope this helps