Formula to Get total per (2000)

Topic

New Reply

Could someone help me with a formula to count different entries, per manager and put the total in another table. I have a small example attached. In the real version there are a lot more entries to deal with. I need the total first aids,medicals etc to go in the appropriate column. thanks

Reply | Quote

Replies

What is missing in the attachment is the expected results. Care to provide the desired/expected figures?

Reply | Quote

Does this explain it?

Reply | Quote

One way is to use a pivot table, see attached.

Reply | Quote

Pivot tables still scare me, but I see the benefit. thanks

Reply | Quote

Looks like you want a multi-conditional count…

In H3 enter, copy across to J3 then down:

=SUMPRODUCT(–($B$3:$B$9=$G3),–($E$3:$E$9=H$2))

where B3:B9 house Managers and E3:E9 aid Types, while G3 houses a criterion manager and H2 a type criterion.

Another option is to bulid a pivot table from your data.

Reply | Quote

The formula is just what I needed. thanks all

Reply | Quote