I want to use the below formula but instead of SUM IF I need to work out Average IF

Sue van Niekerk

=SUMIFS({Quality Checks Tracker FY21-22 Range 1},{Quality Checks Tracker FY21-22 Range 2}, [Primary Column]@row)

So i want to work out the average %% if the first column says "full Inspections" ect ect

I have the formula working with sumif on the first number column but now need to work out the average %%

Bassam Khalil

@Sue van Niekerk

If you like share me as an admin on a copy of your sheet after removing any sensitive data and I will check it for you. Because it's words on my sample sheet.

My email: bassam.k@mobilproject.it

Bassam Khalil

Hi @Sue van Niekerk

Hope you are fine, please try the following formula:

=IFERROR(AVERAGEIF({Quality Checks Tracker FY21-22 Range 1}, "full Inspections", {Quality Checks Tracker FY21-22 Range 2}), "")

the following screenshots show the results:

the references

Sue van Niekerk

Have inserted formula but it gives me 0% - what am i doing wrong :-O

Bassam Khalil

@Sue van Niekerk

If you like share me as an admin on a copy of your sheet after removing any sensitive data and I will check it for you. Because it's words on my sample sheet.

My email: bassam.k@mobilproject.it

Sue van Niekerk

I got it working :-) THANK YOU SO MUCH!!!!

Bassam Khalil

@Sue van Niekerk

Excellent, I will be happy to help you any time.