Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting every 3 rd row
The formula "=countif(a1:a1000,"A??")" is working, but i have to count every
3rd row from a1 to a1000 like a1,a4,a7 etc., How to write formula to do this task. Thanks for reply |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting every 3 rd row
=SUMPRODUCT(--(MOD(ROW(A1:A1000),3)=1),A1:A1000)
"ezil" wrote: The formula "=countif(a1:a1000,"A??")" is working, but i have to count every 3rd row from a1 to a1000 like a1,a4,a7 etc., How to write formula to do this task. Thanks for reply |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting every 3 rd row
"joel" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A1000),3)=1),A1:A1000) "ezil" wrote: The formula "=countif(a1:a1000,"A??")" is working, but i have to count every 3rd row from a1 to a1000 like a1,a4,a7 etc., How to write formula to do this task. Thanks for reply Thanks for the formula but where to put the condition How the formula like with the condition |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting every 3 rd row
i had to do it like this
in column B put =MOD(Row(),3) this gives a 0 for rows, 3,6,9 .... then in another cell =SUM((B1:B100=0)*(A1:A100="A")) entered as an array formula this, B1:B100=0 , is what gives values for every third row and this A1:A100="A", counts A's the array formula thus counts where col B=0 and Col A is "A" "ezil" wrote in message ... "joel" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A1000),3)=1),A1:A1000) "ezil" wrote: The formula "=countif(a1:a1000,"A??")" is working, but i have to count every 3rd row from a1 to a1000 like a1,a4,a7 etc., How to write formula to do this task. Thanks for reply Thanks for the formula but where to put the condition How the formula like with the condition |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting every 3 rd row
=SUMPRODUCT(--(MOD(ROW(A1:A1000),3)=1),--(A1:A1000="A??"))
"ezil" wrote: "joel" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A1000),3)=1),A1:A1000) "ezil" wrote: The formula "=countif(a1:a1000,"A??")" is working, but i have to count every 3rd row from a1 to a1000 like a1,a4,a7 etc., How to write formula to do this task. Thanks for reply Thanks for the formula but where to put the condition How the formula like with the condition |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting help | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting Rows Then Counting Values in Columns | Excel Programming | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |