Count every month

[GUNI]

I have a claim spread sheet, were i have to do a diagram for every month Authorised, Rejected and Refer claims. I used =month(A1) so I get the month by number.
currently i just use a filter out by months and by letters A,F,J. Would be there something less manually as caountif formula don't work with the filter.

Thank you very much in advance.

 

[T. Valko]

I have a claim spread sheet, were i have to do a diagram for every month Authorised, Rejected and Refer claims. I used =month(A1) so I get the month by number.
currently i just use a filter out by months and by letters A,F,J. Would be there something less manually as caountif formula don't work with the filter.

Thank you very much in advance.

What exactly do you want to count?

 

[GUNI]

Hi T.Valko<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I count how much claims have been authorised referred or rejected every month.<o></o>
<o></o>
I would very much appreciate it.<o></o>
Thank you.<o></o>

 

[T. Valko]

Hi T.Valko<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I count how much claims have been authorised referred or rejected every month.<o></o>
<o></o>
I would very much appreciate it.<o></o>
Thank you.<o></o>

What version of Excel are you using?

Are the dates all within the same year?

Do you need to count for only the month or do you need to count for both the month AND the year?

 

[GUNI]

Hi,
I use 2003excel, and report i needed for one year - monthly.
I manage to finish, i add another column of claim decision code and used pivot table. Work out pretty good

 

[T. Valko]

Hi,
I use 2003excel, and report i needed for one year - monthly.
I manage to finish, i add another column of claim decision code and used pivot table. Work out pretty good

Good deal. Thanks for feeding back!