gpt-4-0314· OpenAI
WildChat-4.8M (AI2)
write me an excel formula where it gives the average of all the numbers in Column "FP"…
- User
write me an excel formula where it gives the average of all the numbers in Column "FP" when the value in Column "AV" in the same row is the value "Alex"
- Assistant
To achieve this, you can use the AVERAGEIFS function in Excel. The formula would look like this:
=AVERAGEIFS(FP:FP, AV:AV, "Alex")