Countif multiple columns

windoz

New Member
Joined
May 21, 2014
Messages
13
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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.

NumberContribution
10
10
51
32
41
40
21
10
12
221
10


<1Counts go here18%
1Counts go here73%
2Counts go here9%
3Counts go here0%
>3Counts go here0%

I would appreciate any guidance or assistance please.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I think you're looking for SUMIF...

Book2 (version 1).xlsb
ABCDEF
1NumberContribution
210<18
310133
45124
53230
641>30
740
821
910
1012
11221
1210
Sheet1
Cell Formulas
RangeFormula
F2:F6F2=SUMIF($B$2:$B$12,E2,$A$2:$A$12)
 
Upvote 0
Solution
and there you go!

Fantastic Cubist!

Really appreciate your response!
 
Upvote 0

Forum statistics

Threads
1,223,162
Messages
6,170,431
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top