Hi all,

I have a long headers row (A2:BK2) and in the row below there are dates
corresponding to the above. Some of the second row (A3:BK3) does not
have data in various cells and what I want to do is count these empty
cells.

The headers row contains a number of repititions (NB: I didn't create
this spreadsheet - it's horrible!), so in theory I should be able to
use COUNTIF to find out which cells are empty.

My problem is I don't know how to get Excel to first do a COUNTIF on
the header row, and then only COUNTIF there is no data in the row
below.

I hope that makes sense. Any suggestions?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=559314