I have attached a sample of the problem I am trying to solve. The table is labeled from item A to I. Below that is the cost of each item. I will have people selecting the items as shown.
I have manually calculated the total cost but don't know where to start with calculating the cost.
I want to have a calculated total cost.
Any help would be greatly appreciated.
Thank you in advance
Hi Jim
Use SUMPRODUCT for it.
=SUMPRODUCT((B3:J3*$B$2:$J$2)+(B4:J4*$B$2:$J$2))
=SUMPRODUCT((B5:J5*$B$2:$J$2)+(B6:J6*$B$2:$J$2))
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Enter this in K4 and pull down:
=IF(A3="","",SUMPRODUCT(B3:J4*$B$2:$J$2))
"Relax. What is mind? No matter. What is matter? Never mind!"
Thank you both so much. Both work perfectly.
You are welcome!
So pls, mark your thread, as SOLVED
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks