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
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