I'm an Excel trying to muddle through some things for work..
How do I count and average only the number that corresponds with the adjacent string?
I've attached a copy of the workbook and the picture below if anybody can help.
forum average q.png
I'm an Excel trying to muddle through some things for work..
How do I count and average only the number that corresponds with the adjacent string?
I've attached a copy of the workbook and the picture below if anybody can help.
forum average q.png
You could try
=AVERAGEIF($A$2:$A$10,D2,$C$2:$C$10)
What do the $ signs stand for?
See information about absolute and relative references.
https://support.office.com/en-gb/art...e-5f0d8d0baca9
I think I get what you mean, but I need it to be smart enough to pick out the numbers next to a certain string (bad area 1, bad area 2, etc.) i.e. if there were more "bad area 3" rows with Potent.Con.Cnum numbers, it would count and average the right numbers in the third column.
Does that make sense?
See change to you example file.
Formula fixed to use rows 2 to 10000
Thanks pal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks