| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to sum a column only when an entry exists in a different colum
So..I want to sum a column, but only consider the cell's value in this sum if
a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different colum
hi
what is the column to sum? what is the entry on the same line in the other column? what is the other column? regards FSt1 "Labby" wrote: So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different c
I have column E that contains dollar amounts. I'd like to sum these items
only if something is entered in a different column..column L which contains dates. Is that what you mean? Thanks for being so quick...this is great! "FSt1" wrote: hi what is the column to sum? what is the entry on the same line in the other column? what is the other column? regards FSt1 "Labby" wrote: So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different colum
Try...
=SUMIF(L1:L6,"0",E1:E6) HTH Regards, Howard "Labby" wrote in message ... So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different c
Perfect! Thank you! Yes, I believe that worked! My report has nearly 5000
lines, so I checked it by choosing just a few lines. Thanks again! "L. Howard Kittle" wrote: Try... =SUMIF(L1:L6,"0",E1:E6) HTH Regards, Howard "Labby" wrote in message ... So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different c
hi
yes that is exactly what i mean. i think L. Howard Kittle beat me to it. he has a good formula that might work. try that. i did. and it works. regards FSt1 "Labby" wrote: I have column E that contains dollar amounts. I'd like to sum these items only if something is entered in a different column..column L which contains dates. Is that what you mean? Thanks for being so quick...this is great! "FSt1" wrote: hi what is the column to sum? what is the entry on the same line in the other column? what is the other column? regards FSt1 "Labby" wrote: So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different c
Can you take a stab at this for me? I'd like to search in column H for one
of 9 or 10 words (call it w1); then add their same line, column E, which is a currency field, so that I can repeat this for each word, having totals for each word. "Labby" wrote: Perfect! Thank you! Yes, I believe that worked! My report has nearly 5000 lines, so I checked it by choosing just a few lines. Thanks again! "L. Howard Kittle" wrote: Try... =SUMIF(L1:L6,"0",E1:E6) HTH Regards, Howard "Labby" wrote in message ... So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to sum a column only when an entry exists in a different c
hi
off to the side create a small table. you will need a formula similar to the sumif that work for each word. you can then sum the sums for a grand total. regards FSt1 "Labby" wrote: Can you take a stab at this for me? I'd like to search in column H for one of 9 or 10 words (call it w1); then add their same line, column E, which is a currency field, so that I can repeat this for each word, having totals for each word. "Labby" wrote: Perfect! Thank you! Yes, I believe that worked! My report has nearly 5000 lines, so I checked it by choosing just a few lines. Thanks again! "L. Howard Kittle" wrote: Try... =SUMIF(L1:L6,"0",E1:E6) HTH Regards, Howard "Labby" wrote in message ... So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes sense. Tried reading through the sumif explanation, but can't figure it out. Can someone please help me? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I write a formula to select the last entry in a colum | Excel Discussion (Misc queries) | |||
| how to sum items in a column if there exists some more refernces | Excel Worksheet Functions | |||
| Count column if heading exists | Excel Discussion (Misc queries) | |||
| Sum and Offset: to add from a point to the last entry in the colum | Excel Worksheet Functions | |||
| Determining if a value already exists in column(s) | Excel Discussion (Misc queries) | |||
Linear Mode
