Marcelo, That worked, I just has to flip the formula (y and z). I hate to
ask but can you explain $ symbols role in the formula. That's a new one for
me?

"Marcelo" wrote:

Hi jay

try to use:

=sumproduct((isnumber($Y$2:$Y$268))*($z$2:$z$268))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jay" escreveu:

I'm trying to figure out how to add a columns of numbers if there is a number
in an adjacent column. So for example if cell Y245 and Z245 both contain
numbers then Y245 would be added to the sum but if if Z245 did not contain a
number then Y245 would not be counted.

I'm thinking this is a SUMIF calculation but am unsure of how to input the
data properly. My Ranges are Y2:Y268 and Z2:Z68.

Any help on this would be greatly appreciated. Thanks!