Conditional Sum

D

danw

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
 
S

Sandy Mann

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top