Henrik wrote...
. . . Let's say that sum the numbers in column A when the value in
columb B is
greater than 9 and omit observations with #N/A.

3 2
6 8
8 10
#N/A 12
4 14
#N/A 4
5 14

I propose the following approach (which doesn't work) even though, I
thought it
did in the past:

{=SUM(A1:A7*ISNUMBER(A1:A7)*(B1:B79))}

As far as I know, there is no way to solve this using a sum(if())
combination.
...

Well, not if you confuse IF(x,y) with x*y. Try using a *REAL* IF().

=SUM(IF(ISNUMBER(A1:A7)*(B1:B79),A1:A7))


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=318871