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