Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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()

=average(filter(c3:c44;b3:b44="n"))
share|improve this answer

Not the answer you're looking for? Browse other questions tagged .