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

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!

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

--

HTH

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


"Cheryl B" <Cheryl wrote in message
...
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!

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