Got it working!! Thanks for the quick response,

Mike
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43B8071C.96EB0AF2@verizonXSPAM.net...
> =sumproduct(--(a1:a10<>""),--(c1:c10=""))
>
> =sumproduct() likes to work with numbers.
>
> The -- converts True's and False's to 1's and 0's.
>
> Mike wrote:
>>
>> Happy New Year Everyone,
>>
>> Using Excel XP.
>>
>> I have 3 columns of data, A1:C10. I want to count the blanks in C1:C10
>> ONLY
>> if there is data in A1:A10.
>>
>> Example:
>>
>> A B C
>> ----------------------------------------------
>> 1 20 6 5
>> 2 4 1
>> 3 8 6 2
>> 4 4 2
>> 5 8 1 1
>> 6 7 2
>> 7 3 2 2
>> 8
>> 9
>> 10
>>
>> In the above example I need a formula that counts the blanks in C1:C10
>> but
>> only if there is data in A1:A10, so that I get a total of
>> 3 (C2,C4 & C6 are blank). When I use the countblank function it counts
>> all the blanks in C1:C10 (6).
>>
>> Thanks in advance,
>> Mike
>
> --
>
> Dave Peterson