LinkBack URL
About LinkBacks
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
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
This should do it:
Formula:
=AVERAGEIF(A2:A18,"yes",B2:B18)
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
That's great.
Thank you for your quick response.
Rachael
Hi and welcome to the forum
Formula:=AVERAGEIF(A2:A18,"Yes",B2:B18)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks