=SUM(IF(A3:A5="G",Jan_Inc-Jan_Exp))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"JanetH" wrote in message
...
I have the formula: {=SUM((Jan_Inc),(-Jan_Exp))} where Jan_Inc is a 3
column
by X row array representing three types of income numbers, and Jan_Exp is
the
same for expense numbers. This works fine.

Now I want to SUMIF to include only the rows in the array where there is a
"G" in the first column of the spreadsheet (not in the array). Is there a
way to do this?

Thanks.
--
JanetH