Average IF - help

[coloradoprincess78]

Hi! Looking for a formula that will average multiple cells, only if one cell is blank or zero.

Example: If T2 is blank or Zero, Average N2, P2 and R2

N	O	P	Q	R	S	T	U
Jan-16	Approval	Feb-16	Approval	Mar-16	Approval	Apr-16	Approval
22.07	Approved	25.13	Approved	28.00	Approved		Not Apprvd
87.00	Approved	99.00	Approved	108.00	Approved		Not Apprvd
72.59	Approved	83.75	Approved	99.79	Approved		Not Apprvd

<tbody>
</tbody>

I've tried multiple formulas to get the results that I want, but normally receive a too many arguments error.
I'm sure there is a simple step that I am missing.

Thank you !

 

[Jonmo1]

Welcome to the board.

Try

=IF(OR(T2="",T2=0),AVERAGE(N2,P2,R2),"")

 

[coloradoprincess78]

Perfect! Thank you so much!

 

[Jonmo1]

You're welcome.