Here is my starting formula =PRODUCT(C:D) I would like to write this formula in such a way that it works for the entire column of D. So whatever value I enter in column D is multiplied by the value in column C. D will always be multiplied by C in the same row. (example =PRODUCT(C1:D1) AND THEN =PRODUCT(C2:D2), so on and so forth)
The values in column C are all different, if this was a constant number I would already be a happy camper, but alas it is always different.
Basically, my column B is a part number, column C is quantity, column D is price, finally a specific cell in column E is =PRODUCT(D:D)
If you can tell this is a Menards shopping list, for a home remodeling project that I'm planning. So my list will continue to grow, and numbers will change, both Quantity column and Price column.
I know what I'm trying to accomplish in my head and am having a very hard time iterating that in writing. Hopefully this makes sense to someone else here and can help me out.
Type this in cell E1:
=C1*D1
And drag the formula down the column by the black square in the lower right corner of the cell.
If you want sum of products of all these cells, use:
=SUMPRODUCT(C:C,D:D)