| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
=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! |
|
#3
|
|||
|
|||
|
=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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need formula for percent off of column | New Users to Excel | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Linear Mode
