Formula to return the number of allowances

[Yitzhackm]

Hello all, need some help please .. I have a report that provides the total allowances used per supervisor. need a formula that returns (if possible)

how many allowances 0 to 6

how many allowances 6 to 9

how many allowances 9 to 12

how many allowances over 12.5

per supervisor.

Thanks is advance ..

 

[Logit]

One formula slightly edited for each range.

 

[Yitzhackm]

One formula slightly edited for each range.

This will work if is only one supervisor.. the report returns the data for 16 supervisors.. can the allowances per supervisor be identified?

 

[Logit]

See if this works ... I don't know the layout of your worksheet.

 

[Yitzhackm]

Logit,thanks for your reply. Column A will return the supervisor's name A:1 will be the only heading Supervisor.. see attached

 

[Logit]

See if this works ...

 

[bosco_yip]

In F2, enter,

=TRANSPOSE(FREQUENCY(OFFSET($C$1,MATCH($E2,$A$2:$A$37,0),,12),{6,9,12}))

Select F2:I2, array enter (SHIFT+CTRL+ENTER), then all copy down.

Regards
Bosco

 

[Yitzhackm]

View attachment 43813

In F2, enter,

=TRANSPOSE(FREQUENCY(OFFSET($C$1,MATCH($E2,$A$2:$A$37,0),,12),{6,9,12}))

Select F2:I2, array enter (SHIFT+CTRL+ENTER), then all copy down.

Regards
Bosco

Thank you so much.