hello

i want a formula now i have a button which creates the copy of the seets like as i have written in vba

vba - ActiveSheet.Cells(36, 11).Value = ThisWorkbook.Worksheets("SYN_MAP_BASE" & ActiveSheet.Cells(6, 15).Value).Cells(21, 24).Value


now i want to write a formula as i have written
=SUMPRODUCT((DetailMaperf!R[-11]C[-4]:R[204]C[-4]="Endurance")*(DetailMaperf!R[-11]C[-2]:R[204]C[-2]="Véhicule")

now i want to put the name of work sheet as ("SYN_MAP_BASE" & ActiveSheet.Cells(6, 15).Value) rather then detailmaperf

HOW SHOULD I WRITE THE FORMULA