mathias1979
Technical User
I'm basically doing a time weighted average of a monthly variable...using a formula like:
SUMPRODUCT(A2:A9,B2:B9)/SUM(B2:B9)
where column A has my monthly averages, and column B is the number of days in each month.
The spreadsheet gets added to each month, and I'm trying to automate it so that I don't have to manually update the formual above to account for an additional row each month.
Is there an easy way to do this? Intuitively, I would use ROW(A10) to get the row number where the average resides, then have the summation start at A2 and continue for ROW(A10)-1 rows. But is something like this possible in Excel?
SUMPRODUCT(A2:A9,B2:B9)/SUM(B2:B9)
where column A has my monthly averages, and column B is the number of days in each month.
The spreadsheet gets added to each month, and I'm trying to automate it so that I don't have to manually update the formual above to account for an additional row each month.
Is there an easy way to do this? Intuitively, I would use ROW(A10) to get the row number where the average resides, then have the summation start at A2 and continue for ROW(A10)-1 rows. But is something like this possible in Excel?