AverageIf function with multiple columns

W

wolf8girl

Hello!

I'm trying to determine the average utility costs at my place o
business. I have a spreadsheet set up as such:
Column A: The utility name--Electric, Gas, Water
Column B: The month paid
Column C: The amount paid

How do I get an average of the Electric? I can't seem to get th
AverageIf function to work whereby if column A is "Electric" the
include column C's amount on that row in with the average.

Any help would be hugely appreciated!

Thanks,
w8
 
R

Ron Rosenfeld

Hello!

I'm trying to determine the average utility costs at my place of
business. I have a spreadsheet set up as such:
Column A: The utility name--Electric, Gas, Water
Column B: The month paid
Column C: The amount paid

How do I get an average of the Electric? I can't seem to get the
AverageIf function to work whereby if column A is "Electric" then
include column C's amount on that row in with the average.

Any help would be hugely appreciated!

Thanks,
w8g
Click to expand...

If all that is in column A is Electric, then:

=AVERAGEIF(A:A,"Electric",C:C)

If Electric is only part of what's there, then add wildcards:

=AVERAGEIF(A:A,"*Electric*",C:C)
 
Top