How do you average a column if another column's cells say "Yes"

**RachaelE** · 01-26-2015, 11:24 AM

How do you average a column if another column's cells say "Yes".

So if column A says Yes it counts the amount in column B.

I have attached a spreadsheet as an example.

Thank you

**newdoverman** · 01-26-2015, 11:27 AM

This should do it:

Formula:

Please Login or Register  to view this content.

**Richard Buttrey** · 01-26-2015, 11:27 AM

Hi and welcome to the forum

Formula:

Please Login or Register  to view this content.

**RachaelE** · 01-26-2015, 11:34 AM

That's great.

Thank you for your quick response.

Rachael

How do you average a column if another column's cells say "Yes"

LinkBack

Thread Tools

Rate This Thread

Display

How do you average a column if another column's cells say "Yes"

Re: How do you average a column if another column's cells say "Yes"

Re: How do you average a column if another column's cells say "Yes"

Re: How do you average a column if another column's cells say "Yes"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How can I copy "=Average(A1:A2)" and paste as "=Average(A3:A4)" in next space in column?

Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

[SOLVED] Average cells in column B that have value "Test" in column A

Copy value from column "X" paste into Column "Y" - visible cells

Bookmarks

Bookmarks

Posting Permissions