Hi - I wonder if anyone can help me
I have a SUMPRODUCT problem enclosed - I have a number of items under each pattern with different costs and units
need to sum up for each pattern total value ( i.e. cost x units ) - i've tried but doesn't seem to work:
SUMPRODUCT(--($c$3:$c$17=$C$26),(--$e$3:$e$17))*($f$3:$f$17)
thanks
peter
Im not sure but does this do it
=sumproduct(--($c$3:$c$17=$c26),$e$3:$e$17,$f$3:$f$17)
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Try
=SUMPRODUCT((C3:C17=C26)*(E3:E17)*(F3:F17))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
marvellous - thanks twiggy
rgds
peter
No problem, glad to help.
Remember to mark it solved and tap star to anyone that helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks