You stated half. If O1 = "yes" but what if it doesn't?

Tyro


"Chris" wrote in message
...
I have this problem:

IF O1 = "yes" then j1-p1+m1
but I need to do this from row1:row120 and then get the averages of
row1:row120

Can anyone help me please?