I got it! My problem was that the arrays for INC and EXP were not the same
size. One was 3 columns and the other was 4 columns. When I made them the
same size, it worked. Now I have to figure out how to include that fourth
EXP column!! Thanks!!!
--
JanetH


"Tyro" wrote:

I should have clarified. The formula assumes your array is in rows 1 through
5. Adjust A1:A5 as necessary

Tyro

"Tyro" wrote in message
et...
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