Support Board
Date/Time: Mon, 25 Nov 2024 09:27:57 +0000
Post From: Spread Sheet formulas
| [2024-03-14 10:44:10] |
| User312901 - Posts: 13 |
|
Hi! OK that is what I was suspecting. So now I have noe: =AND(Sheet2!B4 > Sheet2!AF4, Sheet2!E8 > Sheet2!AF4) copied down to several rows. This gives me 1 or 0 for each row. So now I can statically find whether certain range of rows all are true by using: =IF(SUM(Q1:Q5) = 5, 1, 0) or optionally: =AND(SUM(Q1:Q5) = 5) But can I compose the cell reference (Q5 in this case) by using a value from another cell? Basically I'm looking to alter number 5 both in cell reference and as a value we are looking the calculation to match to. |