sumproduct worksheet function

[RichardO]

Hello:

I need your urgent help with the following:

I want to count the number of cells in column C with "Anne" that also
have a "Yes" in column L. Does anyone know why the following formula
is not working? I am getting an message saying the formula I have
entered contains an error.

=SUMPRODUCT(('Daily Auto AP List'!C8:C999="Anne")*('Daily Auto AP
List'!'Daily Auto AP List'!L8:L999="YES"))

Please help. Thank you.


RichardO.

 

[Andy B]

Richard

In the second part of the formula, you have the sheet name twice.

Andy.

 

[RichardO]

you're right, I didn't even notice that. Thanks a lot.


RichardO