SUMIFS - Can criteria be entered directly?

PeterYac 

You can write:

=SUMPRODUCT(SUMIFS(A1:A4, Z1:Z4, {1,2,3,4}))

That says:  sum A1:A4 where the corresponding row in Z1:Z4 equals 1, 2, 3 or 4.

Is that what you want?

-----

But then you write:  ``I don't want to create the range Z1:Z4 [....] I am trying to sum values based in what quarter it is is so the {1,2,3,4}``

If A1:A4 is the range that you want to sum, there must be another range that indicates the quarter.

But I wonder if that other range does not actually contain the quarter numbers 1, 2, 3 and 4.  Instead, does it contain dates that you __interpret__ as belonging to particular quarters?

Bottom line:  if the SUMPRODUCT(SUMIFS...) formula that I provide above does not work for you, I suggest that you upload an example Excel file that demonstrates the problem to a file-sharing website (e.g. onedrive.live.com), and post the download URL in a response here.

PeterYac 

I didn't catch entire idea, perhaps that could be done another way, e.g. using CHOOSE(), but if literally when

=SUMPRODUCT(A1:A4*({1;2;3;4}=3))

or

=SUMPRODUCT(A1:A4*(ConstantsList=3))

if you name above array in Name Manager