# Emergent help!!!!

• I am using MS WORD spreadsheet (EXCEL). I have random 25 integers for each row and there are 100 rows. Now I want to find the sum of the 20 largest integers (out of 25) for each row. What is the fastest/easiest way? Thanks and bow!!!

• what are the maximum and minimum values for your integers?

• Something along these lines I think!

Post back if not

HTH

&lt;a href="http://www.mrexcel.com/relayforlife.shtml" target="new"&gt;&lt;img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"&gt;&lt;/a&gt;

• Iridium,

No, the 25 integer are in a row not in a column.

• Just an example - the formula should work in the same way if applied to a row. Try it out

&lt;a href="http://www.mrexcel.com/relayforlife.shtml" target="new"&gt;&lt;img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"&gt;&lt;/a&gt;

• Iridium,

Thank you very much for your help. I have another question here: how to find how many '0' for each row? For instance, I have 1, 0, 3, 0, 5, 9, 10 for row 1, so I should find 2 '0's. Thanks.