1

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?

Kevin Panko
  • 7,366
superuserNewbie
  • 123
  • 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

1 Answers1

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

=average(filter(c3:c44;b3:b44="n"))
nixda
  • 27,268
mcgyver5
  • 1,101