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? :-)
Perhaaps =SUMPRODUCT((R2:R483>29.99)*(R2:R483<100))
=SUMPRODUCT((R2:R483>29.99)*(R2:R483<100)*(R2:R483)) if you want the value
or
=SUMIFs(R2:R483,R2:R483,">29.99",R2:R483,"<100")
for a count
=countIFs(R2:R483,">29.99",R2:R483,"<100") or the formula given in the previous post
Last edited by davsth; 01-27-2020 at 11:53 AM.
The R2:R483 part was eaten by my keyboard
Pepe
Give the request says "Number of account balances " and "track amounts owed to me " i thought you were answering "the number of account balances" and had not missed it at all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks