I am wondering if it is possible to format a range so that a countifs formula will recognize it.
I am using this formula. It returns the correct count for <1000, but I am not sure how to format the ranges >=1000 & <=4999 so that the formula will recognize and return a count of the dollar values that fall between those two numbers. I am using reference cells in order to avoid a massive formula.
=COUNTIFS(Kickstarter!$R$2:$R$4115,'Outcomes Based on Goals'!$A$1,Kickstarter!$F$2:$F$4115,'Outcomes Based on Goals'!$C$2,Kickstarter!$D$2:$D$4115,'Outcomes Based on Goals'!A3)
I am using this formula. It returns the correct count for <1000, but I am not sure how to format the ranges >=1000 & <=4999 so that the formula will recognize and return a count of the dollar values that fall between those two numbers. I am using reference cells in order to avoid a massive formula.
=COUNTIFS(Kickstarter!$R$2:$R$4115,'Outcomes Based on Goals'!$A$1,Kickstarter!$F$2:$F$4115,'Outcomes Based on Goals'!$C$2,Kickstarter!$D$2:$D$4115,'Outcomes Based on Goals'!A3)
Plays | ||
Goal | Successful | |
<1000 | Less Than $1,000 | 141 |
>=1000 & <=4999 | $1,000 to $4,999 | 0 |
$5,000 to $9,999 | 0 | |
$10,000 to $14,999 | 0 | |
$15,000 to $19,999 | 0 | |
$20,000 to $24,999 | 0 | |
$25,000 to $29,999 | 0 | |
$30,000 to $34,999 | 0 | |
$35,000 to $39,999 | 0 | |
$40,000 to $44,999 | 0 | |
$45,000 to $49,999 | 0 | |
>500000 | Greater than $50,000 | 0 |