Sign up ×
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:

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

closed as off-topic by fixer1234, DavidPostill, ncdownpat, mdpc, BlueBerry - Vignesh4303 Aug 3 at 12:27

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question is not about computer hardware or software, within the scope defined in the help center." – fixer1234, DavidPostill, ncdownpat, mdpc, BlueBerry - Vignesh4303
If this question can be reworded to fit the rules in the help center, please edit the 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

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