Sum(Sumifs formulas using cell value for array criteria

General Excel Questions & Answers

Last Post by Velouria 2 years ago

3 Posts

3 Users

0 Reactions

8 Views

RSS

christian.a

(@christian-a)

Posts: 1

New Member

Topic starter

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!

Posted : 15/02/2023 12:40 pm

Anders Sehlstedt

(@sehlsan)

Posts: 957

Prominent Member

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

Posted : 15/02/2023 8:07 pm

Velouria

(@debaser)

Posts: 833

Member Moderator

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.

Posted : 16/02/2023 8:19 am