Dave,

SUMPRODUCT is an array function so it doesn't need to be array entered,
Excel already knows. It only needs array entering if there is some other
nested function within that is not capable of processing arrays directly,
and that needs to be array entered.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave" wrote in message
...
Bob

I thought it was necessary for the logical operation, I mean the
comparison
of each cell in the range to F15 and C15. Obviously I'm wrong. Thanks
for
saving me the key strokes.

Dave

"Bob Phillips" wrote in message
...
Ctrl-Shift-Enter is not necessary.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dave" wrote in message
...
Hey lost

This should work for you

=B15-(SUMPRODUCT(--(F53:F533=F15),--(I53:I533=C15),H53:H533))

confirm with cntrl+shft+enter

Let me know if this works for you.

Dave

"lostinformulas"
<lostinformulas.2a0xvz_1151350206.1051@excelforu m-nospam.com wrote in
message
news:lostinformulas.2a0xvz_1151350206.1051@excelfo rum-nospam.com...

I need to add another condition to my formula.

=$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533))


The formula I'm using is works now I need each line to look at Column
F
and If it equals F15 then do the formula and conditions below.

Each row needs to look at $F53:$F533 to see if it = F15
Each row needs to look at $I53:$I533 to see if it = C15
B15 - (sum( of the true amounts in $H53:$h533

Any help will be appreciate my boss wants this change this afternoon
if
possible. Please make me look good.


--
lostinformulas

------------------------------------------------------------------------
lostinformulas's Profile:
http://www.excelforum.com/member.php...o&userid=35229
View this thread:
http://www.excelforum.com/showthread...hreadid=555740