Forum Discussion
Solved
Help with formula involving multiple columns
Hi I dont know if this is been addressed in the past or if someone could help me. I am trying to sum or count the times one item shows in a list but has values between one amount and the other. Fo...
This formula in column F produces a count of 10 for instances between 0 and 10
=COUNTA(FILTER(C2:C16,(C2:C16>0)*(C2:C16<=10)*(B2:B16="Market Area 1")))In column G, this one gave a count of 5, for instances between 11 and 30
=COUNTA(FILTER(C2:C16,(C2:C16>=11)*(C2:C16<=30)*(B2:B16="Market Area 1")))If instead of a count, you prefer a SUM, just change the COUNTA to SUM. Since these are numbers being counted, you could also use COUNT rather than COUNTA.
This formula in column F produces a count of 10 for instances between 0 and 10
=COUNTA(FILTER(C2:C16,(C2:C16>0)*(C2:C16<=10)*(B2:B16="Market Area 1")))
In column G, this one gave a count of 5, for instances between 11 and 30
=COUNTA(FILTER(C2:C16,(C2:C16>=11)*(C2:C16<=30)*(B2:B16="Market Area 1")))
If instead of a count, you prefer a SUM, just change the COUNTA to SUM. Since these are numbers being counted, you could also use COUNT rather than COUNTA.