+ Post New Thread
Results 1 to 2 of 2
How do you do....it? Thread, Excel formula in Technical; We have some print tracking software that gives a monthly reading of how many prints a user has done. What ...
  1. #1
    arthur231283's Avatar
    Join Date
    Sep 2008
    Location
    Dartford
    Posts
    164
    Thank Post
    34
    Thanked 37 Times in 23 Posts
    Rep Power
    19

    Excel formula

    We have some print tracking software that gives a monthly reading of how many prints a user has done. What we would like to do is charge departments. I have a list of departments and which users are in them.

    So I need a formula (Or a way) to count a users amount of prints if they are in a particular department then give me the total

    I have attached a very simplified version of how it would look. The top list is the departments and the members of the departments and below that is the users and the number of prints (If only is looked that simple in reality).

    So I guess it would be a bit like this, any user from A12:A23 are present in A2:A5 count the relevant cell in B12:B23.

    Does anyone know the best way of doing this?

    excelformula.jpg

  2. #2

    bladedanny's Avatar
    Join Date
    May 2009
    Location
    Sheffield
    Posts
    1,296
    Thank Post
    191
    Thanked 309 Times in 230 Posts
    Rep Power
    170
    Hi,

    How's this?

    Not sure if it's exactly what you're after but it may be something to start from.

    It basically scans the print log and SUMIF for each user. Then a simple SUM to work out pages for each dept.

    Hope it helps.
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula Copy Problem
    By sqdge in forum Office Software
    Replies: 26
    Last Post: 10th February 2013, 06:18 AM
  2. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 03:34 PM
  3. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  4. office for mac excel formula question.
    By russdev in forum Office Software
    Replies: 2
    Last Post: 9th May 2008, 11:51 AM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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