Conditional Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top