Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have this google-doc: https://docs.google.com/spreadsheet/ccc?key=0Avl3X68NxHC-dFY2YWgzTnRVZm1xaWlBTFl6TU9NTkE&usp=sharing

Now I am trying to calculate the average (=average()) of the percentages of my tasks. But I want to have only the average percentage of all tasks, where the "Projektaufgabe" is set "n".

How can I do that?

share|improve this question
I would suggest that you copy a small sample set of data here so we can see what you're looking at without having to go off-site to look at it. Off the top of my head, I have a feeling you want to look at AVERAGEIF(). –  Jonathan Garber Nov 26 '13 at 15:16
From my understanding this can be resolved as of now with the same function that Excel uses AVERAGEIF as that function is available with the latest Google Spreadsheets. –  Darius May 25 at 21:39

1 Answer 1

Excel would use averageif(), but according to this link, a Google spreadsheet does not have such a function.

But you can instead use filter()

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.