=SUMIF(E:E,"N",G:G)


Regards,

Peo Sjoblom

"Cheryl B" wrote:

a b c d e f
g h i
5/15/2004 2585 SCHMIDT, PLUMBING R N 484.00 85.25 10 ????

I need to have column "I" be the sum of column G if column e = N.
The last solution I received from Andy B didn't work as it just brought the
column
name over.
Help please!