Countif multiple columns

[windoz]

Hi,

I'm currently trying to work out the following but been struggling to get the correct answer. If the contribution (See box below in what I am trying to do) is greater than or equal to 1, then it banks the number to the left handside and then updates the count in the box below.

For example, if the contribution is 1, it will bank the number 5,4,2 and 22 and add this to the overall count which exceeds >3 in the box below, total should be 33.
Another example is that if the contribution is 0, it will bank into the countif with a total of 8 in the final box below.
Another example is that if the contribution is 1, it will bank into the countif with a total of 33 in the final box below.

I did try to use countif however it requires a more complicated formula. I am using Office 2019 Professional Plus.

Number	Contribution
1	0
1	0
5	1
3	2
4	1
4	0
2	1
1	0
1	2
22	1
1	0

<1	Counts go here	18%
1	Counts go here	73%
2	Counts go here	9%
3	Counts go here	0%
>3	Counts go here	0%

I would appreciate any guidance or assistance please.

 

[Cubist]

I think you're looking for SUMIF...

Book2 (version 1).xlsb
	A	B	C	D	E	F
1	Number	Contribution
2	1	0			<1	8
3	1	0			1	33
4	5	1			2	4
5	3	2			3	0
6	4	1			>3	0
7	4	0
8	2	1
9	1	0
10	1	2
11	22	1
12	1	0
Sheet1

Cell Formulas
Range	Formula
F2:F6	F2	=SUMIF($B$2:$B$12,E2,$A$2:$A$12)

 

[windoz]

and there you go!

Fantastic Cubist!

Really appreciate your response!