can't get sumproduct to work

**fabrecass** · 08-02-2011, 04:43 AM

column c has a list of names, column d has either a yes or a no, i have a separate summary sheet and i want to count the yes' for each name, my sumproduct formula won't work?

=sumproduct((c:c="name")*(d:d="yes"))

what am i doing wrong?

**arthurbr** · 08-02-2011, 04:51 AM

vl 2003 does not accept entire ranges like C:C you will have tio use C1:C65536 if necessary

**Colin Legg** · 08-02-2011, 05:25 AM

I think Arthur meant C2:C65536

Ideally, try to keep the range sizes as small as possible. SUMPRODUCT uses a lot of brain power, so you might find your spreadsheet calculations grinding to a halt if you overuse it.

**fabrecass** · 08-02-2011, 05:31 AM

thanks alot guys, sorted.

**arthurbr** · 08-02-2011, 05:45 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save