Jun 21 2021 05:20 PM
Jun 21 2021 09:46 PM
Jun 21 2021 09:52 PM
@ThisTwinMom You can use SUMPRODUCT for this. It multiplies column B by D (E,F,G etc.) and then sums it all up. See picture below. Enter the formula where you want it, adjust ranges is needed and copy it towards the right. Beware to use the dollar signs in the reference to the cells in column B. This will keep the range fixed when you copy the formula to the right.