Hi,
My sheet records data on a monthly basis. I use MAX to find the highest
number (which can be in any of the four weeks of the month). I then need
to SUM numbers in the row below.
For example cells A1:A4 contain the following: 20;31;70;64
Cells B1:B4contain the following: 2;4;1;6
The MAX function will select 70 I then need to to SUM the 2;4;1
I hope that this makes sense - can you help please?
Many thanks
Tony
--
y_not
------------------------------------------------------------------------
y_not's Profile:
http://www.excelforum.com/member.php...o&userid=19947
View this thread:
http://www.excelforum.com/showthread...hreadid=565625