| Home |
| Search |
| Today's Posts |
|
#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? . |
| 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) | |||
Threaded Mode
