H
hawkeyeted
I have 2 columns that I am trying to total into one cell. Column B is the
number of items ordered. There are about 35 different items. Column D is the
price of each item with each item having a different price. I want a cell at
the bottom to reflect the number of items ordered multiplied by each of their
prices for a grand total. I know how to do this the long way
=(B1*D1)+(B2*D2)+...etc but is there an easier way to do this? A function I
don't know about?
number of items ordered. There are about 35 different items. Column D is the
price of each item with each item having a different price. I want a cell at
the bottom to reflect the number of items ordered multiplied by each of their
prices for a grand total. I know how to do this the long way
=(B1*D1)+(B2*D2)+...etc but is there an easier way to do this? A function I
don't know about?
37)