I am looking to find the average in column b excluding 0 as a value, and only when in column a the value is "a".
I currently have the function averageifs(A2:A13, "a", B2:B13, "<>0") but am told I have entered too few arguments.
I am looking to find the average in column b excluding 0 as a value, and only when in column a the value is "a".
I currently have the function averageifs(A2:A13, "a", B2:B13, "<>0") but am told I have entered too few arguments.
Last edited by az1234; 02-11-2020 at 02:56 PM.
You are missing range to average in your construct.
Ex:
averageifs(B2:B13,A2:A13, "a", B2:B13, "<>0")
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you for the quick response and help!
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks