Microsoft Office Forums - View Single Post - Problem> do not include 999 in calculations

Thread: Problem> do not include 999 in calculations

View Single Post

Old

05-07-2019, 03:08 PM

Alansidman Alansidman is offline

Alansidman is offline

Alansidman uses Windows 10

Windows 10 Alansidman uses Office 2019

Alansidman uses Office 2019

Office 2019

עַם יִשְׂרָאֵל חַי

Join Date: Apr 2019

Location: Steamboat Springs

Posts: 79

Alansidman will become famous soon enough

Alansidman will become famous soon enough

Default

Use this formula to exclude 999 from the calculation

=AVERAGEIF(B2:J2,"<>999") and copy down.

Reply With Quote