View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Sum cells based on two criteria

use an AND function inside the SUMIF

SUMIF(range1,AND(month=2,Name="ANN),range2)

the 2nd parametter of the SUMIF can be any function or equationthat returns
a TRUE or FALSE response

"Ann" wrote:

I need a total (count) broken down by user (name) and month. What formula can
I use to achieve this? SUMIF only allows 1 criterion, whereas I have two
(name and month).

A2 = Count
B2 = Name
C2 = Month

EXPECTED RESULTS:
Jan Feb Mar
Smith 20 4 15
Jones 16 12 19