LinkBack URL
About LinkBacks
k25 
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks