A
AJPendragon
I have a SUMPRODUCT for numbered data, but also require it for % data. My
SUMPRODUCT is:
=SUMPRODUCT(--(Sheet2!B4:B573=A6),(Sheet2!C4:C573))
This provides a total % figure of 475%, but I want the average of the 5
figures selected (it could be as many as 1-5 figures) - is this possible with
the SUMPRODUCT formula.
Thanks for looking
SUMPRODUCT is:
=SUMPRODUCT(--(Sheet2!B4:B573=A6),(Sheet2!C4:C573))
This provides a total % figure of 475%, but I want the average of the 5
figures selected (it could be as many as 1-5 figures) - is this possible with
the SUMPRODUCT formula.
Thanks for looking