Need Help On SUMPRODUCT

[savethisid]

Hi, I am new to this forum...but honestly i am loving it...get to learn and implement so many new things...okay now to the porblem that i am facing.

Scenario
In sheet 1, I have User Name in column D5:D5000 and Date starting APR to Dec in column F5:F5000 in format DD-MMM-YY.

Problem
in Sheet 2, I have a list of users with 100 fixed names in column A, what i need now is a formula in Sheet 2, column B I need product count month wise. See example below

Month Aug Month Sep
User Name Product1 Product2 Product3 Product1 Product2 Product3
A 10 20 30 40 10 10 20
B 50 60 70 80 60 40 60
C 90 100 50 10 0 10 10

please help

 

[Robert Mika]

Under which column(Product..) heading is the month sitting?
Is it in a form of "Month Aug" or "Month" & "Aug"....

To post your data in a better format:

You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.

 

[savethisid]

Hi Robert,

Thanks a ton for helping me

The answer to your question is that Product1 is under column "C" and similarly Product2 would be under column "D" and so on.

Thanks for the