Counting items by criterias in 2 columns

[Alexandru Dan Mitache]

Hello All...

For the follwing table, I need formulas in F1, F2, F3 and F4, in order to count the total number of customers, from A8 to A17, matching the criterias shown in A1, A2, A3, A4.
Condition: countings only for customers with sales in both years!
Can anyone help me?

Thank you!

 

[hagia_sofia]

Hello, please test the following:

=ROWS(FILTER(F8:F17,(B8:B17>0)*(D8:D17>0)*(F8:F17>0)))

=ROWS(FILTER(F8:F17,(B8:B17>0)*(D8:D17>0)*(F8:F17<0)))

=ROWS(FILTER(G8:G17,(B8:B17>0)*(D8:D17>0)*(G8:G17>0)))

=ROWS(FILTER(G8:G17,(B8:B17>0)*(D8:D17>0)*(G8:G17<0)))

 

[FormR]

Hi, something like this maybe.

Book1
	A	B	C	D	E	F	G
1						1
2						2
3						2
4						3
5		Year 2023		Year 2023		Diff
6		Sales	Markup	Sales	Markup	Sales	Markup
7
8	A	100	10	200	5	100	-5
9	B	300	30	200	40	-100	10
10	C	300	30			-300	-30
11	D			500	10	500	10
12	E	500	20	100	10	-400	-10
13	F	500	50	500	50	0	0
14	G	400	10	400	20	0	10
15	H	300	30	300	20	0	-10
16	I					0	0
17	J	800	80			-800	-80
Sheet1

Cell Formulas
Range	Formula
F1	F1	=COUNTIFS($B$8:$B$17,">0",$D$8:$D$17,">0",$F$8:$F$17,">0")
F2	F2	=COUNTIFS($B$8:$B$17,">0",$D$8:$D$17,">0",$F$8:$F$17,"<0")
F3	F3	=COUNTIFS($B$8:$B$17,">0",$D$8:$D$17,">0",$G$8:$G$17,">0")
F4	F4	=COUNTIFS($B$8:$B$17,">0",$D$8:$D$17,">0",$G$8:$G$17,"<0")
F8:G17	F8	=D8-B8

 

[Alexandru Dan Mitache]

hagia_sofia & FormR...
Thank you very much!!! Problem solved!
Both solutions are working perfectly!
Kind regards,
Alexandru

 

[FormR]

Thank you very much!!! Problem solved!

Just a word of warning with the ROWS(FILTER(.. method, I'm not sure that you get a good result when you have no customers that match any of the criteria.