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
- Marksheet format in excel - Guide
- How to clear formatting in excel - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
1 response
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