Excel Formatting
Closed
Bill Tom
Kevin@Radstock
- Posts
- 1
- Registration date
- Sunday March 10, 2013
- Status
- Member
- Last seen
- March 10, 2013
Kevin@Radstock
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
1 reply
Kevin@Radstock
Mar 10, 2013 at 03:38 AM
- Posts
- 42
- Registration date
- Thursday January 31, 2013
- Status
- Member
- Last seen
- April 26, 2014
Mar 10, 2013 at 03:38 AM
Hi Bill Tom
Use the AVERAGEIF for your question.
=ROUND(AVERAGEIF(C:C,">0")/AVERAGEIF(A:A,1,B:B),2)
For your criteria in column A. You will be better off referencing another cell. For example D1, where you have data validation set up as a list, Source: "1,2,3,4,5,6" without the quotes
Kevin
Use the AVERAGEIF for your question.
=ROUND(AVERAGEIF(C:C,">0")/AVERAGEIF(A:A,1,B:B),2)
For your criteria in column A. You will be better off referencing another cell. For example D1, where you have data validation set up as a list, Source: "1,2,3,4,5,6" without the quotes
Kevin