Excel Formatting
Closed
Bill Tom
Posts
1
Registration date
Sunday March 10, 2013
Status
Member
Last seen
March 10, 2013
-
Mar 10, 2013 at 12:38 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 10, 2013 at 03:38 AM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Mar 10, 2013 at 03:38 AM
Related:
- Excel Formatting
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Highlight cell if another cell contains any text ✓ - Excel Forum
1 reply
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Mar 10, 2013 at 03:38 AM
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