Hello,
It would be amazing if anyone could help me out with the following two formulas.
1) I have a set of 5 different sums in their own cells in 2000 rows
K1 - L1 - M1 - N1 - O1
23 - 45 - 110-120- 150
10 - 25 - 101-119- 129
etc
I'd like to get if K1 falls within the range of 1-20. If t does, get a checkmark (or any other symbol that indicates that it does). If it doesn't fall within that range, to get a cross or an X symbol.
If it helps in any way, the Character code for the checkmark is 252 and for the X is 206.
2) Also I have the following formulas after the help of other members.
=SUM(COUNTIF(B3:G3,{2,3,5,7,11,13,17}))
=COUNTIF(CB3:CB60, CHAR(206))
=COUNTIF(BB3:BB69,1)
These formulas are used in a sheet called Analysis. Is it possible to get the results in a separate sheet called +Analysis?
If anyone has the answer to any of the above please post it.
Thanks
Sans
Bookmarks