I'm in need of the formula to track amounts owed to me within specific ranges in a single column.
For example, I'm need to track "Number of account balances $30-$99.99."
I'm wanting to use =SUMIF(R2:R483,">29.99",R2:R483,"<100") but get the message "You've entered too many arguments for this function." If I use SUMIFS, I get "You've entered too few arguments for this function."
Where have I gone wrong? :-)
Bookmarks