Possible to get multiple data reports back from one column of data using this sumproduct formula?

[Jennifre]

Hi, I'm using this sumproduct formula to get the percentage of 1s in a column of data (thanks Aladin!).

I'm wondering if it's possible to change the formula to give me several percentages for 1s, 2s, 3s, and 4s in column AP [of data matches between numbers in columns DG and AM, to explain the formula below], and to give them in the same cell -- is this possible?

Ideally, I"d like to get back a row of cells reading something like:
10% - 25% - 3% - 67%, to indicate the % of 1s 2s 3s and 4s in that column.

=SUMPRODUCT(
--($DG$2:$DG$1364=$AM1385),
--ISNUMBER(MATCH(AP$2:AP$1364,{1},0)))/
SUMPRODUCT(
--($DG$2:$DG$1364=$AM1385),
--($AP$2:$AP$1364>=0)
--($AP$2:$AP$1364<=4))

 

[Aladin Akyurek]

In which cell did you enter this formula?

 

[Jennifre]

Hi there, I entered it into AP1385.

I'm curious how that influences your answer or thinking! Looking forward to your response, Aladin, thanks, as always! ;0