Countif in SUBTOTAL

[Supersats]

Hi,
I recognise I cannot use Countif in Subtotal, but cannot understand how to apply sumproduct.

My formula would be =subtotal(countif(v2:v5352),"U") to return how many U's there are in the range V2:V5352, after the data has been filtered.

Any help would be greatly appreciated as I am out of my depth here, but there is no one else that can help!!

Thanks
|Chris

 

[Eric W]

Try:

=SUMPRODUCT(--(V2:V5352="U"),SUBTOTAL(103,OFFSET(V2,ROW(V2:V5352)-ROW(V2),0)))

 

[Supersats]

Try:

=SUMPRODUCT(--(V2:V5352="U"),SUBTOTAL(103,OFFSET(V2,ROW(V2:V5352)-ROW(V2),0)))

Eric,

Thank you so much, this is amazing

 

[Eric W]

Glad to help, thanks for the feedback.