Hello,
I am looking for a formula to do the following:
If any cells in Column C = B2, Then average the corresponding cells in
Column J...
I was thinking
=SUMPRODUCT((Data!$C$2:$C$181=B$3)*(AVERAGE(Data!J 1:J180)))... But it
just gives me an inaccurate total.
Any help would be appreciated!
Thanks!
--
raspywench
------------------------------------------------------------------------
raspywench's Profile:
http://www.excelforum.com/member.php...o&userid=20717
View this thread:
http://www.excelforum.com/showthread...hreadid=484061