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?

closed as off-topic by fixer1234, DavidPostill, nc4pk, mdpc, BlueBerry - Vignesh4303 Aug 3 '15 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, nc4pk, mdpc, BlueBerry - Vignesh4303
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    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 '15 at 21:39

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

But you can instead use filter()


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