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?
|