Counting and Indexing?

[jlp]

I asked a similar question previously and thought I could apply what I learned from that question to this question - but somewhere along the line I got lost.

What I want to do seems pretty easy and it SHOULD be something I could figure out on my own but I think what I'm missing is the understanding of how the formula's/functions can work together to get my answer.

Below, please find a mock up of what I want to achieve.
1. I want to return the number of "True's" given for Supplier A, then the number of "False's" given for Supplier B.
Then I want it to go down to the next Supplier and have it give me the number of "True's" for that Supplier, then the number of "False's" for that supplier; and so on.

Suppl Name	PO			TRUE​	FALSE​
Supplier A	TRUE		Supplier A	2​	3​
Supplier A	TRUE		Supplier B	2​	0​
Supplier A	FALSE		Supplier C	0​	1​
Supplier A	FALSE		Supplier D	0​	1​
Supplier A	FALSE		Supplier E	1​	1​
Supplier B	TRUE		Supplier F	1​	0​
Supplier B	TRUE
Supplier C	FALSE
Supplier D	FALSE
Supplier E	TRUE
Supplier E	FALSE
Supplier F	TRUE

So from my previous question I understand that I want to use pcs/parts from the following formula:
=LET(a,INDEX(UNIQUE($A$3:$B$62),,1),COUNTA(FILTER(a,a=$M3)))
The part of the formula that is in blue is the part I'm not sure what to do with. I'm assuming that I want to do some kind of COUNT but I'm not sure how to specify the counting of "TRUE" and "FALSE".

Thank you for any feedback you can give me.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	Suppl Name	PO			TRUE	FALSE
2	Supplier A	TRUE		Supplier A	2	3
3	Supplier A	TRUE		Supplier B	2	0
4	Supplier A	FALSE		Supplier C	0	1
5	Supplier A	FALSE		Supplier D	0	1
6	Supplier A	FALSE		Supplier E	1	1
7	Supplier B	TRUE		Supplier F	1	0
8	Supplier B	TRUE
9	Supplier C	FALSE
10	Supplier D	FALSE
11	Supplier E	TRUE
12	Supplier E	FALSE
13	Supplier F	TRUE
14
Sheet6

Cell Formulas
Range	Formula
D2:D7	D2	=UNIQUE(A2:A13)
E2:F7	E2	=COUNTIFS(A:A,D2#,B:B,E1:F1)
Dynamic array formulas.

 

[jlp]

=COUNTIFS(A:A,D2#,B:B,E1:F1)

Thank you for your speedy reply Fluff! Unfortunately I am receiving a #SPILL! error

 

[Fluff]

Clear cells in the region & then re-enter the two formula in D2 & E2 only.

 

[jlp]

Clear cells in the region & then re-enter the two formula in D2 & E2 only.

Did not receive the SPILL error but am receiving all 0's - please see attached

Count Lates per Supplier 3.xlsx

Shared with Dropbox

www.dropbox.com

=COUNTIFS(A:A,D2#,B:B,E1:F1)

 

[Fluff]

You don't have the criteria in E1 & F1

 

[awoohaw]

YOu need the words TRUE and FALSE in E1 and F1, I think.
Nevermind, I did not get a notice that there was a new post, before I hit send.

 

[jlp]

I missed that detail - of course that fixed my issue!

Thank you so much - and I do understand the formula!

 

[Fluff]

You're welcome & thanks for the feedback.