Multiple COUNTIF formula that ignores #N/A

[Fin Fang Foom]

I'm trying to get this formula to work. I have a multiple count formula but I'm still getting #N/A errors how can I ignore them ?

This what I have so far:

=SUMPRODUCT((ISNA(Sheet1!B9:B100=F2))*(Sheet1!C9:AG100>0))

 

[NBVC]

Don't you need an If(isna... somewhere?

Like: If(isna(sumproduct(....),"",sumproduct(....))?

 

[Aladin Akyurek]

I'm trying to get this formula to work. I have a multiple count formula but I'm still getting #N/A errors how can I ignore them ?

This what I have so far:

=SUMPRODUCT((ISNA(Sheet1!B9:B100=F2))*(Sheet1!C9:AG100>0))

Since there is no problem description available, a guess is due:

=SUM(IF(ISNUMBER((Sheet1!B9:B100=F2)+0),(Sheet1!C9:AG100>0)+0))

which must be confirmed with control+shift+enter.

 

[Fin Fang Foom]

I just can't get it to work.


I used your formula and still get a #N/A error.

Look in cell I10 the answer suppose to be 2. Because he worked 2 days.

And cell I2 is a data validation list.

=SUM(IF(ISNUMBER((Sheet1!B9:B100=F2)+0),(Sheet1!C9:AG100>0)+0))

 

[Fin Fang Foom]

bump

 

[Domenic]

Try...

=SUM(IF(B3:B8=I2,IF(ISNUMBER(C3:H8),(C3:H8>0)+0)))

...confirmed with CONTROL+SHIFT+ENTER. Adjust the range accordingly.

Hope this helps!

 

[Fin Fang Foom]

Once again Domenic Thank You very much. ray: