I am trying to place a weighted average into a summary line that covers a certain range below it. This range is dynamic.
For example:
This is what I have, but I need to get a weighted sum of 0.572 next to the 296526.43
The regular formula would be something like:Please Login or Register to view this content.
{=SUM(((C3:C19)/C2)*(D3:D19))}
The code that I have come up with so far is:
relay is the worksheet namePlease Login or Register to view this content.
I keep running into a Type Mismatch error on:
What am I doing wrong? OR how can I change this?Please Login or Register to view this content.
Thanks
Bookmarks