use
=sumproduct((a2:a22="ad")*(b2:b22="Jan")*c2:c22)

--
Don Guillett
SalesAid Software

"JP" wrote in message
...
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?