I'm trying to make a cell Average a column of numbers only if a specific dropdown list is selected in the same row.
Example: A1 through A10, each cell has a dropdown list of 3 different job tasks. B:1 through B10 records the amount of time to complete each task. I want to write a formula to put the Average time to do task #1 in cell C11. The Average time to do task #2 in cell C12. The Average time to do task #3 in cell C13.
Does anyone out there know how to do this?
Sorry for breaking the rules originally. I'm trying to only post this question once, in one forum. Is there a certain amount of time I need to wait to repost? I understand why the first time w/ multiple posts was deleted, but last time I only did one and it was deleted too. I'm not sure if this post will be deleted, if so, please tell me what I need to do.
Thank you.
Also Posted Here
Try this formula (it's an array formula, so you must press CTRL+SHIFT+ENTER after typing it in)
=AVERAGE(IF($A$1:$A$10="Task1",$B$1:$B$10))
Replace "Task1" with the name of your tasks, and adjust ranges as necessary.
Note: after pressing CTRL+SHIFT+ENTER, you'll see braces {} entered around the formula - this is normal for array formulas.
sb70x7, your posts would not have been deleted if you followed the Rules these concern thread titles (this one is not descriptive enough), cross posting (as you have done at Ozgrid) to name but a few!
This thread has been locked by another Moderator for those offences, please feel free to re-post with a good title and if you must cross post provide a link to any other cross post you have made.
We visit or have visitors from all forums, so should you not make us aware of these we will find out and ultimately you would not be able to post here again!
We don't want that, we want to help and are pleased to do so, just a couple of rules to abide by and everyones happy.
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks