Share via

how do i calculate average in excel

vy 20 Reputation points
2023-12-08T21:29:51.7+00:00

how do i calculate average cost if these are the values i have.

months gallons cost
jan 63041.00 258460.95
feb 49311.10 194405.64
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
0 comments
Accepted answer
  1. Barry Schwarz 3,651 Reputation points
    2023-12-08T21:44:13.49+00:00

    There is a built-in function called AVERAGE.

    Which average are you interested in?

    • The average consumption per month would be AVERAGE(63041,49311.1).
    • Similarly for the average cost per month.
    • The average cost per gallon for jan is simply 258460.95/63041.
    • Similarly for feb.
    • The total average cost per gallon SUM(258460.95,194405.64)/SUM(63041,49311.1)
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.