Forum Discussion

eminemaths's avatar
eminemaths
Copper Contributor
Feb 01, 2024
Solved

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

Let's use the example below. I would like to count the number of 1s in column C, IF 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? ...
  • OliverScheurich's avatar
    Feb 01, 2024

    eminemaths 

    =COUNTIFS(A1:A9,105,B1:B9,1,C1:C9,1)

     This can be done with COUNTIFS.