Search results

Hi Luke and shrivallabha, thanks for your help. when i am trying this sumproduct formula in same sheet where the data contains the formula is working fine. But when i am trying this in another sheet (other than the data sheet) the formula doesnt work. Could you please help me in to that...

Hi, a 10 a 11 a 25 a 12 a 1 b 25 b 50 b 37 b 48 c 35 c 45 c 52 c 12 c 75 In the above data how can i find out the max number for a, b and c by using one formula. Can you help me how can i use sumproduct formula. However i am aware about the array formula...