ExcelBanter - View Single Post - averageif function

Thread: averageif function

View Single Post

#4

Report Post

curtll

curtll is offline

Junior Member

Posts: 9

Default

Ive tried {=AVERAGE(IF(C2=0,0,C2:C3))} and several different variations of it.

Quote:

Originally Posted by Don Guillett

Post what you have tried

--
Don Guillett
SalesAid Software

"curtll" wrote in message
...

Hello, Im trying to have information from C2:C3 averaged unless C2 is
blank or 0. If it is 0 or blank I want B3 to be blank. I am trying to
add this formula into B3. Ive tried a lot of different formulas and
nothing is working. Can anyone help?

--
curtll

Reply With Quote

Reply With Quote