Hi,
I have a table of data that has been filtered using one of the columns in the report.
I would like to sum the values in each column that haven't been excluded by the filter and also calculate the weighted average of the same, filtered data using the SUMPRODUCT function.
Can someone please suggest how I do this.
Thanks!
Bookmarks