Need help in conditional count, count values only when column heading matches

[rajtak]

I want to count 'a' (absent) of each employee listed in column C to D for each particular month as shown in the table Column G thru H. Please suggest a formula to achieve it.

The Screenshot below will better explain what I'd like to do.

Thank you in advance for your help

 

[arthurbr]

A Pivot Table will do the trick

 

[MrJoosten]

Hello Rajtak,

If you don't mind setup the ranges, you can use this formula: =COUNTA(C3:C27)

Maybe someone else can make a more dynamic formula. I don't have the knowledge.

Goodluck!

 

[MrJoosten]

ofcourse! xD

 

[rajtak]

Please let me know how to use Pivot Table for this?

 

[MrJoosten]

Hi Rajtak,

1. Select a cell where you want to plot your pivottable
2. Go to insert -> Pivottable
3. Select A2:D30 as range (or whatever range you want)
4. -Row label: monthname
-Values: count of Tom, count of rick

This should do it I guess

 

[arthurbr]

And BTW there are hundreds of tutorials all over the web...

 

[rajtak]

I have resolved it using Pivot Table. Thank you very much