so i have this table:
1
2
3
4
5
6

now I want to do a count if it's higher than 3.5 so i have this: =countif(A1:A6,">3.5") but what if I want to replace that 3.5 with a cell that contains that info? So cell B1 is 3.5 so I want to instead use that # that is in B1 as the criteria. I tried doing:
=countif(A1:A6,">B1") but it doesn't work. How read a cell as a criteria? Also I wanted to add to that cell too like B1+2 so the total would be 5.5 if B1 is 3.5 in this example. Or adding 2 or more cells as the total like B1+B2

Thanks for the help.