Assuming data within A2:D7

Inputs set:
In E1: C, In G1: SV, In H1: 300

Then placed in I1:
=SUMPRODUCT((A$2:A$7=F1)*(B$2:B$7=G1)*(C$2:C$7=H1) ,D$2:D$7)
will return the required: 500 from D2:D7

I1 can be copied down to return correspondingly for other input sets in
E2:H2, E3:H3 etc. Adapt the ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dubbo" wrote:
I am trying to find a solution to the following data - hav tried all sorts to
no avail
BRANCH DEPT ACCOUNT TOTAL
C SV 300 $450
W SV 310 $200
C PT 300 $500
W PT 300 $100
C SV 300 $ 50
C SV 310 $200

The list of data extends over about 5000 lines with many variations per column
What i am want to determine is a formula that will tell me the total sum of
the TOTAL column when it meets a certain criteria from the first 3 columns -
ie what is the total $ where the branch is C - Department is SV - and the
Account is 300 (answer is $450 + $50=$500) - any ideas please.