counting specific number in one column but cell choice will be dependent on two other columns

Question

Let's use the example below.I would like to count&nbsp;the number of 1s in column C,&nbsp;IF&nbsp;the value of A is 105, and B is 1. The end product will be a number actually. How can I write a formula for this? I tried XLOOKUP, VLOOKUP, INDEX and INDIRECT functions but I was not successful. Thank you.A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C105&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;105&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;105&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;105&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;105&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0105&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;106&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;108&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;112&nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;

oliverscheurich · Accepted Answer

eminemaths&nbsp;=COUNTIFS(A1:A9,105,B1:B9,1,C1:C9,1)&nbsp;This can be done with COUNTIFS.&nbsp;

Forum Discussion

counting specific number in one column but cell choice will be dependent on two other columns

Share

Resources