Help to sum too long

[excel dummy 2]

Hi there i need help i have been working this out useing a sum function but i now have over 100 lines ahh what i need is an easer way. the charts like this
I need to work out the totel cost per day for 100+ lines

Qty
Cost M T W T F S S

100 1 10 3
123 1 10




100 123 1000 300 1230

[EdMac]

If you can post a copy of your sheet it will be easier to help you.

[excel dummy 2]

Sory i did try to make the layout look like my spred sheet but it didnt work so i have attached a small example of what im doing

any help gratefully reseaved

thanks J

[EdMac]

Use this in B11 and copy across

=SUMPRODUCT(($A$3:$A$10)*(B3:B10))

Regards

[excel dummy 2]

Thanks ed easy when you know how then.

[EdMac]

Practice makes perfect!

Check out this site for more uses of SUMPRODUCT - it's a veery useful function.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Thanks for the feedback