Enter this array formula:

Try =SUMPRODUCT(--(A1:A5="G")*((Jan_inc)-(Jan_Exp)))


Tyro

"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