Results 1 to 7 of 7
  1. #1
    BakerMan
    Guest

    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. #2
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Get total per (2000)

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

  3. #3
    BakerMan
    Guest

    Re: Formula to Get total per (2000)

    Does this explain it?

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formula to Get total per (2000)

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

  5. #5
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.
    Microsoft MVP - Excel

  6. #6
    BakerMan
    Guest

    Re: Formula to Get total per (2000)

    The formula is just what I needed. thanks all

  7. #7
    BakerMan
    Guest

    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
  •