Simple sumif question

[easybpw]

Hello and thanks in advance for any help offered.

This is a simple sumif problem but for some reason my brain doesn't seem to want to function today.

In words this is what I want to do: if I4:I15>21 then sum I4:I15, then divide that by 7 and then subtract 3. So if it i not greater than 21 I want the result to be -0-.

This should be easy but...

Thanks again!

Bill

 

[AhoyNC]

Does this work for you?

=IF(SUM(I4:I15)>21,(SUM(I4:I15)/7)-3,0)

<COLGROUP><COL style="WIDTH: 224pt; mso-width-source: userset; mso-width-alt: 10898" width=298><TBODY>
</TBODY>

 

[easybpw]

Yes, thanks. I knew it would be as easy as it looks. I appreciate the help.