Hi All,
Need a little help with Sum(Sumifs formula.
I currently have "=Sum(Sumifs( Sumrange, Criteria Range1, 2022, Criteria Range2, {"A","Z"}))".
I know that I can use "=Sum(Sumifs, Criteria Range1, 2022, Criteria Range, Z1:AD1))" will work if I list each criteria individually in separate cells, but it is possible to reference a single cell for the criteria in curly braces?
Thanks in advance!
Hello,
I am not sure what your question is, can you upload a sample file showing what data you have and what you want to get? An alternative method is to use SUMPRODUCT.
Br,
Anders
If you have TEXTSPLIT available to you, you can use:
=Sum(Sumifs( Sumrange, Criteria Range1, 2022, Criteria Range2, TEXTSPLIT(some cell, ",")))
where the cell in question has A,Z in it.
