Forum Discussion

santiaaaago's avatar
santiaaaago
Copper Contributor
Apr 06, 2022
Solved

Two values in a cell

Hello,

 

I was looking for write two values in a single cell to count them. For example, the attached image shows cell1 having values 1 and 2; cell2 only 1 and cell3 3 and 1. I want excel to count how many times it has 1 in that range, which should be 3 times. However, according to excel it is only once since the only cell that has 1 alone is cell2. Is there any way that I can add 2 values in a cell so excel recognise as a separate value?

 

Thanks for reading;

Santiago

 

  • santiaaaago 

    =COUNT(SEARCH(1,D6:D8))

    Maybe with this formula if you want to count the number of occurrences. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

2 Replies

  • santiaaaago 

    =COUNT(SEARCH(1,D6:D8))

    Maybe with this formula if you want to count the number of occurrences. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.