Sumproduct Formula

[madhatrs26]

I'm trying to find how many times a specific user in column A(User) appears in sheet 1(Data) according to each month in column G(Date). Please assist me in this question.

Thanks,
Excel Forum Sumproduct Formula.xlsMadhatter

[ConneXionLost]

In cell B2 of your Sumproduct formula Sheet, try:

Please Login or Register  to view this content.

Cheers,

[tigeravatar]

madhatrs26,

Welcome to the forum!
In sheet 'Sumproduct Formula' cell B2 and copied over and down:
=SUMPRODUCT((Data!$A$2:$A$373=$A2)*(TEXT(Data!$G$2:$G$373,"mmm")=B$1)*(YEAR(Data!$G$2:$G$373)=2012))

EDIT: Beat to the answer by ConneXionLost

[darkyam]

Try =SUMPRODUCT(($A$2:$A$373=A2)*(MONTH($G$2:$G$373)=11)*(YEAR($G$2:$G$373)=2011)). Also, a pivot table might be a good answer.

Edit: At least you're not the slow one, tigeravatar.

[madhatrs26]

ConneXionLost thank you much that worked perfectly!

Madhatter

[madhatrs26]

I will also place other posts into my archives thank you all!!

Madhatter

[ConneXionLost]

Take note of the others since they included the year.

[darknation144]

Please mark thread as solved.