Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average,Countif
{=AVERAGE(IF((MOD(ROW(CLM10000!C3:C646),7)=3)*(C3: C646<""),C3:C646))}
I have this entered in cell Adjust PtsC1. As I understand it it gives the average of a column using the data in every 7th row, starting with the 3rd row. It seems to work well, but my problem is when I try to drag it down (even with Ctrl+Drag). I've changed the formula {=AVERAGE(IF((MOD(ROW(CLM10000!C3:C646),7)=4)*(C3: C646<""),C3:C646))}, so it should use every 7th row starting with the 4th row. Is there a trick to copying, pasting or moving Array formulas? Any help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average, Countif | Excel Discussion (Misc queries) | |||
COUNTIF and AVERAGE only cells in unhidden rows | Excel Discussion (Misc queries) | |||
Excluding Zero's from Average (SumIF / CountIF) | Excel Worksheet Functions | |||
Countif cell greater than average | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions |