Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use SUMIF and AND together
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? |