Summary of data

[turtel]

Hello wonderful peeps of Chandoo,

I need help on a worksheet. I have a column J (Repeat Test Slide) in each tab for the year. I need to count how many times there was a repeat for each of the studies on column B. The counts should go on the summary data tab on D39:D59 for each of the studies that has a repeat. I uploaded a copy of the worksheet. I hope I made sense on my explanation. Any help would be much appreciated.

Thanks,
Turtel

 

[Smallman]

Hi Turtel

In your Summary data tab make row 4 equal to your sheet names eg change Jan to January in Cell D4 do the same for the other months.

In D5 put this formula

=COUNTIF(INDIRECT(D$4&"!B6:B308"),$B5)

Drag it down and across.

Take care

Smallman

 

[Herbert Seidenberg]

Excel 2010 with free PowerPivot Add-In
Completely redone and dragged into the new era.
http://www.mediafire.com/view/97xraqbdy9s3m9d/04_28_14a.xlsx
http://www.mediafire.com/view/h4e3q4o60cc92gw/04_28_14a.pdf

 

[Debraj]

with respect to Smallman..
You can use.. below formula too...
Just to skip the task of conversion Jan to January

=COUNTIF(INDIRECT(TEXT(1&D$4,"mmmm")&"!B:B"),$B5)

Smallman​

 

[turtel]

Sorry all for the late response but thank you all for the formulas, it worked great.