Hi there,
I want to average a set of numbers (column B) on the condition that it belongs to a certain value i.e 1 (column A). However, i want to remove all 0 (Zero) values in column B from the calculation. Does such a formula exist?
A B
1 0
2 11
1 15
1 0
2 6
2 9
1 15
2 0
I need to apply the formula to a spreadshee with circa 20,000 rows of information.
Thanks in advance for any assistance.
Adam
Bookmarks