Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· OpenAIAi2 WildChat-4.8M (AI2)

write me an excel formula where it gives the average of all the numbers in Column "FP"…

  1. 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"

  2. Assistant

    To achieve this, you can use the AVERAGEIFS function in Excel. The formula would look like this:

    =AVERAGEIFS(FP:FP, AV:AV, "Alex")