# Thread: Formula to Get total per (2000)

1. ## Formula to Get total per (2000)

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

2. ## Re: Formula to Get total per (2000)

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

3. ## Re: Formula to Get total per (2000)

Does this explain it?

4. ## Re: Formula to Get total per (2000)

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

5. ## Re: Formula to Get total per (2000)

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.

6. ## Re: Formula to Get total per (2000)

The formula is just what I needed. thanks all

7. ## Re: Formula to Get total per (2000)

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•