1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

What is the syntax for averageif?

I have a table tracking gas prices week to week, and another projecting gas expenses by month. I have algorithm =SUM(AVERAGEIF(N2:N35, “<>o”)*4)-H20)

That calculates the average weekly fill up cost, ignores cells with a value of 0, multiplies the results by 4 (week to month), and subtracts any weeks that already happened from the projected monthly total.

Now I want to alter that from ignoring 0 to only consider cells with a greater 30 value, trying to future proof the algorithm from considering weeks where I have pto or holidays and thus don’t burn gas commuting in; but I don’t understand the arguments for the average of or how to change them. If I’m not mistaken right now it’s just ignoring 0 like it’s a text string?

submitted by /u/RoadTheExile
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#AVERAGEIF
#gas prices
#gas expenses
#table
#algorithm
#weekly fill up cost
#projected monthly total
#cells with a value of 0
#greater than 30 value
#pto
#holidays
#commuting
#syntax