| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Countif on non adjacent rows
Something along the lines of:
=COUNTIF(Offset('QA Input'!$E$9,(row(A1)-1)*5,0,1,252),'Monthly Report'!$D$1) Drag fill down the column. -- Regards, Tom Ogilvy "St@cy" wrote in message ... =COUNTIF('QA Input'!$E9:$IV9,'Monthly Report'!$D$1) The formula above returns the correct information, but I need to copy it down the column with the row changed to multiples of 5. (In other words, I need the result of every fifth row.) Does someone know a short cut or the programming for a macro? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF with adjacent columns | Excel Worksheet Functions | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| Countif in non adjacent columns | Excel Worksheet Functions | |||
| Compare adjacent fields in adjacent rows | New Users to Excel | |||
| How do I use countif across non-adjacent cells? | Excel Worksheet Functions | |||
Threaded Mode
