Limit A/F Record count to ONLY "SI" rows

[jim may]

In my multi-column AutoFilter Column B (2)
I have

WhosePrc (this is the header in B7)
SI (1st record in B8)
SI Average

zCP
zCP Average

SI
SI Average

zCP
zCP Average

SI
SI Average

zCP


zCP Average

Ordinarily I would use = subtotal(3,B8:B1000), but the count is Much greater than
the SI count ONLY.. How can I alter my formula to Subtotal only the SI records?

 

[Domenic]

Is this what you mean?

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B8:B1000,ROW(B8:B1000)-ROW(B8),0,1)),--(B8:B1000="SI"))

Hope this helps!

 

[jim may]

Domenic -- YOU ARE EXACTLY right !!!

Thanks,

After sending this 30 minutes ago -- I cound not find it posted on the board, so I sent it again -- CAUSING it to show up twice - don't you know grrrrrrrr

Thanks again,

Jim

 

[jim may]

Domenic,

With some "after-thought" -- not in a million years would I have come up with the formula you did. Is there some "background" on why these certain "side-references" are necessary in order to finally get to the answer. I previously thought a CSE formula
would have been the answer, but I guessed wrong,,,,

Thanks again,

Jim

 

[Domenic]

Have a look at Aladin's explanation here...

Hope this helps!