Count

[rohit]

Hi all,

There are two worksheets in my workbook. The first sheet is used to
record data entry stats. In the first sheet, the first column contains
the data entry date, and the second column contains the data entry
name. I am using the second sheet to maintain the stats of each data
entry person on a monthly basis. How do i achieve this without using
macros. Thanking in advance.

Regards,
Rohit

 

[David Heaton]

Hi all,

There are two worksheets in my workbook. The first sheet is used to
record data entry stats. In the first sheet, the first column contains
the data entry date, and the second column contains the data entry
name. I am using the second sheet to maintain the stats of each data
entry person on a monthly basis. How do i achieve this without using
macros. Thanking in advance.

Regards,
Rohit

Rohit,

If on your second sheet you have the months numbered 1 to 12 across
columns B:M
And the names in Col A row 2 onwards , try this in cell B

=SUMPRODUCT((Sheet1!$B$1:$B$15=A2)*(MONTH(Sheet1!$A$1:$A$15)=B1))

Regards

David

 

[rohit]

Rohit,

If on your second sheet you have the months numbered 1 to 12 across
columns B:M
And the names in Col A row 2 onwards , try this in cell B

=SUMPRODUCT((Sheet1!$B$1:$B$15=A2)*(MONTH(Sheet1!$A$1:$A$15)=B1))

Regards

David

Hi David,

Many thanks for your help.

Regards,
Rohit

 

[David Heaton]

Hi David,

Many thanks for your help.

Regards,
Rohit- Hide quoted text -

- Show quoted text -

Rohit,

your welcome.

Regards

David