Text version of SUMIFS

[JOEE1979]

I have a formula

=SUMIFS((INDIRECT(AL9&"!F:F")),(INDIRECT(AL9&"!G:G")),(CONCAT((TEXT(V$4,"DD-")),(TEXT($D$2,"MMM-YY")))),(INDIRECT(AL9&"!N:N")),$W6)

However, I have text in F:F, and I know SUMIFS returns a number.
How would I be able to fix this to make if give me a text and not a number?

Thanks

 

[Peter_SSs]

Unfortunately I am not having any luck in trying to replicate your data to test with.

 

[JOEE1979]

Unfortunately I am not having any luck in trying to replicate your data to test with.

I think I might have to add some helper columns in the "2024" sheet and the do a sumif function in the "Current Month"

 

[JOEE1979]

I ended making a helper column in '2024 (I identified each shop by a different number).
Then in 'Current month I did a SUMIF to extract that number, and finally another column to replace that number with the original shop.
Took a while, but its done. I wish excel had a text version of SUMIFS, maybe for the next project.

Thank for a all the help, now I can relax, lol

 

[Peter_SSs]

Glad you got it sorted. Thanks for letting us know.