G
Guest
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.
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.