sumif conditions?
Posted by Rob on July 19, 2001 8:02 PM
ok...i have a table with the following format
<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
