hi
i'm looking to get a weighted average from a table (in 'database format') for specific rows. i'm working on excel 2010.
below might help to convey the idea of what i am trying to achieve, although the actual solution will probably differ considerably.
=if(criteria1="text";if(criteria2="text";if(criteria3="text"));
true:
SUMPRODUCT(array1;array2)/countifs(array1;criteria1="text";array1;criteria2="text";array1;criteria3="text";
false:
0)
thanks for your help!
i'm looking to get a weighted average from a table (in 'database format') for specific rows. i'm working on excel 2010.
below might help to convey the idea of what i am trying to achieve, although the actual solution will probably differ considerably.
=if(criteria1="text";if(criteria2="text";if(criteria3="text"));
true:
SUMPRODUCT(array1;array2)/countifs(array1;criteria1="text";array1;criteria2="text";array1;criteria3="text";
false:
0)
thanks for your help!