Can you use two array constants in a formula?

Hi Everyone

I'm having trouble with putting two array constants in a formula. Not sure if you can use array constants in one formula or if i should try something else, Sumproduct maybe?

Anyway, in my attached example i want to count number of 1,2,3's in the number column and any of those numbers that have either a/c in the letter column.

Yes you can use two arrays, but one has to be vertical & the other horizontal, like

Formula:

Please Login or Register  to view this content.

Thanks but what do you mean by vertical and horizontal?

The only difference i can see here is use of a semi colon?

The semi-colon is a row separator & the commas is a column separator. If you remove the sum at the start the formula will spill in 2 directions like
Excel 365 (Windows) 32 bit

	D	E	F
2	1	0	0
3	0	0	1

Sheet: Sheet1

Where the 1st row is counting the "a" & the 2nd is counting "c"

Ahh ok i think i get it.

Just to be clear, in your example
Where the 1st row is counting the "D" & the 2nd is counting "F"

That's what's happening right?
Thank you for your quick replies, much appreciated.

No the row in red is counting the number of "a"s for 1, 2 & 3, whilst the row in blue is counting the number of "c"s

Count	1	2	3
a	1	0	0
c	0	0	1

Ah right ok, i get it now.

Thank you very much for your help.

You're welcome & thanks for the feedback.