View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default 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?