Can I use SUMIF and AND together

J

JP

I have several columns of data. One column is a persons initials, the second
column is months (Jan, Feb, etc) and the third column is revenue. I am
trying to do a SUMIF (or SUMIF(AND) formula that will look at columns 1 and 2
and then sum from column 3.

Example,

A B C
AD Jan 10
AD Jan 10
AD Feb 25
DB Mar 50
KV Apr 75

I need the formula to add up all the revenue in January associated with AD.

Can this be done?
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A20="AD"),--(B2:B20="Jan"),C2:C20)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
S

SteveG

SUMPRODUCT is probably best but if you want to use SUMIF you could use
this array formula.

{=SUM(IF($A$1:$A$6="AD",IF($B$1:$B$6="Jan",$C$1:$C$6,0),0))}

Commit with Ctrl-Shift-Enter which automatically puts the curly
brackets around the formula, do not type them yourself.

Steve
 

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

Similar Threads

drag formula down from columns that go acros 3
SUMIF Function 2
Formula help needed please 2
IF, AND, OR Function 9
SUMIF with multiple criteria 5
Offset 2
Summing a non continuous range 7
Function Problem 6

Top