Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count specific subtotal values only
I am trying to get a count of the subtotaled cells that have value of "1". I
have searched through previous posts and have not been able to get any of the formulas to return the correct value. The formulas I have tried are and the returns I received are as follows: =SUMPRODUCT(--(D2:D6303="1"),SUBTOTAL(3,OFFSET(D2,ROW(D2:D6303)-ROW(D2),))) =SUMPRODUCT(SUBTOTAL(3,OFFSET(D2:D6303,ROW(D2:D630 3)-MIN(ROW(D2:D6303)),,1)),--(D2:D6303="1")) both returns a 0. without the "' returns 4991 which is the number of subtotals. =COUNTIF($D$2:$D$6303,"1") returns 5115 I've tried several others as well. Any help is greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count zero values before specific date | Excel Worksheet Functions | |||
Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) | |||
Count the number of specific values in a cell | Excel Worksheet Functions | |||
Trying to count specific values | Excel Worksheet Functions | |||
How do I count my data that are between specific values? | Excel Worksheet Functions |