Formula Needed involving IF condition

**silver surfer** · 08-22-2009, 12:27 PM

Hi!!

I have 30 agents who report to me.If have got the tenure for each of the agents please provide me with a formula such that it tells me the number of agents who fall in the bracket of 0-6months,6-12 months and > than 12 months.It should sum up the number of agents falling into these brackets.

Attached is the spreadsheet.

[

**daddylonglegs** · 08-22-2009, 12:32 PM

Hello silver surfer,

Is this already solved?

**silver surfer** · 08-22-2009, 12:49 PM

No this is not solved.I guess I have chosen the option soved in error.

Please provide me with a solution.

Regards

**daddylonglegs** · 08-22-2009, 01:14 PM

OK, I removed "Solved"......

You can use COUNTIF formulas, i.e. in C2:C4

=COUNTIF(B7:AE7,"<6")

=COUNTIF(B7:AE7,">=6")-COUNTIF(B7:AE7,">12")

=COUNTIF(B7:AE7,">12")

Note that 6 months will fall into C3...........