Hi,
I hope someone out there is able to help me with this problem. I have been trying for hours with no avail.
On the TOTALS sheet I need to sum up the values matching up with two criteria items CODE1 and CODE2 for which the values to these are in the RAW DATA tab.
I have tried SUMIF and SUMPRODUCT, but I cant seem to get it to work.
Thanks to anyone who can help me.
Hi,
In C6 and copy across and down:
=SUMIFS('RAW DATA'!$C:$C,'RAW DATA'!$A:$A,TOTALS!C$5,'RAW DATA'!$B:$B,TOTALS!$A6)
Regards
Or with an pivot table.
See the attached file.
The layout could be differant, but it goes for the idea.
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.
You can also use this:
=SUMPRODUCT(--('RAW DATA'!$B$2:$B$6043=$A6)*(--('RAW DATA'!$A$2:$A$6043=C$5)*('RAW DATA'!$C$2:$C$6043)))
Drag it to the right and down
Last edited by AlKey; 09-07-2013 at 01:36 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you very much guys, I used the SUMPRODUCT solution which worked perfectly and the pivot table was very useful as there were some codes I had not piked up and so I was able to do a cross check.
Thanks again guys
Thanks for the reply.
Glad I could help.
If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi, how do i mark it as "Solved".
Thanks
Ignore that.....i found it. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks