Averageifs exclude zero from

**hkaric** · 10-20-2021, 03:41 AM

Hi guys,

I tried some previous threads but just could not get it to work.
Basically, I need the formula to average based on multiple criteria and exclude zero.
File attached.
Thank you.
HK

**WideBoyDixon** · 10-20-2021, 03:47 AM

Just add the non-zero as an extra condition:

Please Login or Register  to view this content.

WBD

**hkaric** · 10-20-2021, 03:54 AM

the only thing i did not try :D thanks a lot,

**wk9128** · 10-20-2021, 05:04 AM

Cell H16 array formula

Formula:

Please Login or Register  to view this content.

Averageifs exclude zero from

LinkBack

Thread Tools

Rate This Thread

Display

Averageifs exclude zero from

Re: Averageifs exclude zero from

Re: Averageifs exclude zero from

Re: Averageifs exclude zero from

Thread Information

Users Browsing this Thread

Similar Threads

AVERAGEIFS (exclude 0 and greater than)

[SOLVED] Averageifs

Averageifs Help.

[SOLVED] Averageifs

Add EXCLUDE Option in table to Exclude from Solver

Averageifs

Averageifs

Bookmarks

Bookmarks

Posting Permissions