Formula for pulling column I ttl in column I for each "e" row that

C

Cheryl B

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!
 
B

Bob Phillips

=IF(E2="N",G2,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top