| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
count
You're welcome!
Biff "Arby" wrote in message ... "Biff" wrote: For the odd numbered rows: =SUMPRODUCT(--(MOD(ROW(H3:H795)-ROW(H3),2)=0),--(H3:H795<"")) For the even numbered rows: =SUMPRODUCT(--(MOD(ROW(H3:H795)-ROW(H3),2)=1),--(H3:H795<"")) Biff "Arby" wrote in message ... "Biff" wrote: I am getting a circular refence error when i replace A1:A10 with H3:H795 which is my range--any ideas--Thx? Move the formula from the referenced range. In other words, don't put the formula in a cell inside the range H3:H795. Biff "Arby" wrote in message ... "Biff" wrote: =SUMPRODUCT(--(MOD(ROW(A1:A10)-ROW(A1),2)=0),--(A1:A10<"")) Biff "Arby" wrote in message ... "Biff" wrote: Count based on what? Here's one way: =SUMPRODUCT(--(MOD(ROW(A1:A10)-ROW(A1),2)=0),--(ISNUMBER(A1:A10))) Counts every other cell starting from A1 to A10 if it contains a number. Biff "Arby" wrote in message ... how would you count everyother cell? Thank you Biff--another question How would I count everyother non blank cell? Thx I am getting a circular refence error when i replace A1:A10 with H3:H795 which is my range--any ideas--Thx? That works despite myself but it appears I need a formula to count all even rows of non blank cells and one that counts all odd rows of non blank cells--any ideas Thx Awesome-perfect--thank you!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to count spinoffs | Excel Worksheet Functions | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
