To enable viewers to see what you are working with and what you are trying to accomplish -- I suggest you share your spreadsheet

1) with some sample but realistic data

2) tell us what you want to accomplish

    in which cell?

    of which sheet?

3) tell us what is your expected response

    along with needed logic/explanation as to why that is the correct result

and then let us take it from there.