Sumproduct query

[RussChilds]

Hi

I'm using this =SUMPRODUCT(--(F:F="Y"),--(P:P="Above Target")) to count how many students with a Y are Above Target. I keep getting this error though: #NUM!

Both cloums are formatted as General.

Can any one help?

Thanks!
Russ

 

[Richard Schollar]

Hi Russ

You can't use whole columns refs - you need to restrict it to eg:

F2:F100

(this is assuming you aren't using xl2007)

 

[RussChilds]

It works now!

Cheers!!