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!
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 [email protected]> wrote in message
news:[email protected]...
> 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!
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks