Count

  • Thread starter Thread starter rohit
  • Start date Start date
R

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
 
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
Click to expand...

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,

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
Click to expand...

Hi David,

Many thanks for your help.

Regards,
Rohit
 
Back
Top