Calculate only visible Cells in a =sum(sumproduct scnario

Good day

I have searched all threads and cant seem to find a specific solution to my scenario.

I have a table of various csv files imported through power query.

I need to add up certain numeric prefixes based on value. The below formula is the only way i could get it to work.

The issue now is to only calculate visible rows, issue is getting more functions in my formula.

=SUM(SUMPRODUCT(--(LEFT(To,4)=2787&""),Cost))

To= c76:C400
Cost= F76:F400

How can i fit a ROW or Count Feature into this formula.

Regards
Jason

You can combine SUBTOTAL and OFFSET for detect.

Do you mind writing me an example? Would this go in my name field?

Hi All

I have tried adding a Subotal, Sum formula to my name reference but my values return 0.

When trying to do SUBTOTAL with OFFSET i get REF#

=SUBTOTAL(9,'Customer Xdrs'!$F$76:$F$4460)
=SUBTOTAL(9,'Customer Xdrs'!$C$76:$C$4460)

Please help, iv struggle with this last step to my spreadseet since last week

Regards

Hi

Please see attached.

Regards