Conditional Sum
 

I am trying to find the sum of all values in the monthly worksheets (JAN:DEC)
that meet two conditions; If A2:A7 on any worksheet=Dallas and B2:B7=AD, sum
the value in Col D. Any help will be greatly appreciated!

Col Col Col
A B C
Location Source Amount
Dallas DB $100
Dallas REF $250
Dallas AD $400
Houston AD $650
Houston DB $100
Austin REF $200

Conditional Sum
 

=SUMPRODUCT((A2:A7="Dallas")*(B2:B7="AD")*C2:C7)

You can also use cell references for "Dallas" and "AD"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"danw" wrote in message
...
I am trying to find the sum of all values in the monthly worksheets
(JAN:DEC)
that meet two conditions; If A2:A7 on any worksheet=Dallas and B2:B7=AD,
sum
the value in Col D. Any help will be greatly appreciated!

Col Col Col
A B C
Location Source Amount
Dallas DB $100
Dallas REF $250
Dallas AD $400
Houston AD $650
Houston DB $100
Austin REF $200