can anyone help me get over this mental blockage please
column A has a list of names
column B has the associated team numbers i.e. 1 to 6
column C records the number of error those names have made for Jan 13
column D records the number of error those names have made for Feb 13
and so on
on a seperate page i would like to know how many errors have been made per team per month
what formula could i use?
thanks
Matt
Last edited by mfhowe1; 11-18-2012 at 07:52 AM.
Please see the forum rules, depending your text in your header (please add your text in a more explaining (usefull) text).
You get better help, if you post an Excel file, without confidentional information.
Please also add the desired result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
unfortunatly my place of work doesnt allow me to upload files
simple pivot table would do this -- row header team row colom month - data errors
sumif has worked a treat thanks, a pivot was impracticle on this occasion
thanks for the feedback and telling offs
@Matt
I used Sumif and Sumproduct to solve your question.
I have attached the file, hope you could download it.
Sumif
Formula:
Please Login or Register to view this content.
Sumproduct
Formula:Please Login or Register to view this content.
Sumif is easier to understand, but Sumproduct could be much more accurate.
Click * to reward me...
Thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks