sumif conditions?

Posted by Rob on July 19, 2001 8:02 PM

ok...i have a table with the following format

&LT;table border="1" width="100%">

AMOUNT
FEE
LOAN OFFICER

BANK1
10,000
1,000
ROB

BANK1
15,000
1,500
ROB

BANK1
20,000
1,600
JOE

BANK2
10,000
900
ROB

BANK2
15,000
1,300
JOE

now, i was wondering if there is a way to sum all the fees for a particular person for a particular bank in my table? say for example, a formula that would count the fees of "ROB" at "BANK1" which would be 2,500. Thanks

Posted by Aladin Akyurek on July 20, 2001 12:03 AM

Rob,

I'll assume that your sample data occupy the range A1:D6, including the column headings.

In e.g., F1 array-enter: =SUM((A2:A6="BANK1")*(D2:D6="ROB")*(C2:C6))

You need to hit CONTROL+SHIFT+ENTER at the same time (not just ENTER) to enter an array faormula.

Aladin

======================

Posted by Rob on July 20, 2001 12:44 AM

yes ARRAYs! thanks again Aladin