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

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

I'd strongly recommend using a Pivot Table instead...

http://peltiertech.com/Excel/Pivots/pivotstart.htm

In article ,
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

That doesn't work Joel.

--
Regards,
Tom Ogilvy


"Joel" wrote:

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

I think I'm closer, but still having trouble getting a sum on the count.
Could you review this array?

{=SUM(IF($B$3:$B$759="Despain",IF($C$3:$C$759="Jan uary",$A$3:$A$759,0),0))}

"Tom Ogilvy" wrote:

That doesn't work Joel.

--
Regards,
Tom Ogilvy


"Joel" wrote:

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

does your source look like this


55 Despain January
25 Despain February


and column C actually holds the month as a string. (not as a date formatted
to display only the month)

--
Regards,
Tom Ogilvy


"Ann" wrote in message
...
I think I'm closer, but still having trouble getting a sum on the count.
Could you review this array?

{=SUM(IF($B$3:$B$759="Despain",IF($C$3:$C$759="Jan uary",$A$3:$A$759,0),0))}

"Tom Ogilvy" wrote:

That doesn't work Joel.

--
Regards,
Tom Ogilvy


"Joel" wrote:

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