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