Requesting Excel formula

[Muthukrishnan V]

Excel 2003 - Column D contains input of various amounts. How do I find
out, for example, the number of entries of "100000" and sum total of these "100000" entries?

 

[Talesind]

countif(range,"100000")
if i've read your question right

 

[Jonmo1]

Perhaps...

=SUMIF(D:D,1000000,D:D)

Hope this helps..