Hi,

How can you add multiple text criteria to an averageifs?

Ex: Averageifs(.......,A:A,"Saul" "Zachary" "Tod")

*I want it to take only the columns that correspond to Saul, or Zachary, or Tod (amongst other criteria that alraedy works).

I tried an or statement and that did not work. I also tried to a seprerate average and if statement with an array, but being that its a very large spreadsheet it runs out of ram.

Cheers,
Saul