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

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel Countifs/Sumproduct with mutil Or statement 3
Function indicating a row have empty value on several columns 2
Find text in N columns and one Row 1
Problem with a Array formula, Please help !! 6
SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN 2
Adding Progressive Months Totals 5
Formula than understands midnight? 25

Top