I have a Sheet with 3415 lines each with a value. Overall they total £7.5m.
I'm trying to create a formula that counts the no of items >0 .AND. <25000.
I looked at doing it in a PIvot Table but could not work out how to change the result, ie 3415 should only be 200 items > 0 but <25000
Can I use Countif as well as ()AND, if so how?
Thanks in advance
I'm trying to create a formula that counts the no of items >0 .AND. <25000.
I looked at doing it in a PIvot Table but could not work out how to change the result, ie 3415 should only be 200 items > 0 but <25000
Can I use Countif as well as ()AND, if so how?
Thanks in advance