View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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?