Averageifs--multiple text criteria

[Sshamash]

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

[SDCh]

Assume column A = Name, column B = Value

You can choose one of this formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note : don't forget Ctrl+Shift+Enter



Regards,
SDCh