I am having problems coming up with a solution to this: I have two columns, one with a list of unit prices and one with an x,2x,3x,etc (where "x" is to denote # of units). I am trying to avoid using just a number for # of units, although I realize a simple sumproduct(a:a,b:b) would probably work.
I am stuck because I cannot figure out how to create the formula to correctly sum the total price (units prices * number of corresponding units) WITHOUT using an actual number for the # of units. If you can't already tell, I am trying to build a budget template where a user will use a drop-down (data validation) to select the number of units, and the total cost will be a sum at the bottom of the column. For a better visual, please see below:
Column A Column B
total cost =WHAT FORMULA to get ((49*1)+(25*2)+ ect...)???