Average Of A Coloumn Of Values, Based On A Critera For Each Value On That Value's Row

Hello, everyone. I'm new here and kinda new to Excel. I've used it before but only for really basic stuff.

Anyway, I want to be able to take the average of a coloumn of values, but the criteria that I want to use is on the same row, but a different coloumn as that value.

I could do it with two different tables, but it would clutter my spreadsheet, and it would force me to make a new table for each different criteria.

The application for my question is to keep track of stats for an online war game.

My particular application at this time is to get an average of various stats for ONLY successful or unsuccessful attacks, but not both. I have arranged the table so that each attack has its own row, and I'm using a 1 or a 0 to denote if the attack was successful or not.

I'm not sure if I've phrased my question clearly or not, but it feels like it's a bit of a tricky and specific situation.

Thank-you for any help that you can offer me.