Home |
Search |
Today's Posts |
#1
|
|||
|
|||
average of everytwo rows?
Are you saying that you have blanks within the data? Can you repeat what the
layout is? What are the columns and what's in each? For each group of 3 rows, the 3rd is the average of rows 1 and 2. What data is in those first two rows? On Tue, 26 Oct 2004 22:56:12 -0500, ForSale wrote: Thanks to everyone. I used Myrna's formula. Should i use the same concept to determine the amount of audits and percent audited? allow me to elaborate. in 106 i have 'total # of audits' and this counts the number of audits, should not count the averages. in 108 i have 'percent monitored'. i would imagine it needs to be something like '=counta(two out of every three rows between a5:a103)/counta(two out of every three rows between c5:c103) thanks again to everyone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Unhide rows | Excel Discussion (Misc queries) | |||
average on rows | Excel Discussion (Misc queries) |