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 ...
4th July 2012, 12:36 PM #1
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?
IDG Tech News
4th July 2012, 12:51 PM #2
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.
By sqdge in forum Office Software
Last Post: 10th February 2013, 06:18 AM
By denon101 in forum How do you do....it?
Last Post: 1st December 2008, 03:34 PM
By RabbieBurns in forum Windows
Last Post: 13th August 2008, 05:31 PM
By russdev in forum Office Software
Last Post: 9th May 2008, 11:51 AM
By DSapseid in forum Windows
Last Post: 7th November 2007, 04:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)