What im trying to do is to take an average of a set of numbers that are next to a certain number in the next column.... this is going to be hard to explain
Basically.... in one column i will have either a 0, 1, 2 or 3. and this could be listed down like this (these are priorities):
and what i need to do is to take an average of the value of the cell next to a specific number.... for example:
So i would have a formula for each of the priorities in a cell that would average the numbers to the right of that priority...
So for example... the average of all priority 2's should be 10+12+30/3 = 17.333. ok now for the twist.....
I may have a 0 value in a cell next to a priority... i do not want this to be averaged. This is my main problem. I have been using a combination of SUMIF functions and COUNTIF functions but cant get anything to work. Here is where i have got so far (e.g. for a priority 2):
- This seems fine.... this is summing the amounts next to a priority... its the next bit thats tricky... i now need to divide this by the number of cells with a value in it (>0) next to that priority (2)
I can do the
but i only need the values next to 2. Can anyone help?
Bookmarks