COUNTIFS with more than and less than parameters

Hello everyone

I'm trying to use the COUNTIFS function to count items where the second parameter looks for a number between two values. No matter what syntax I use, it doesn't seem to work. Could someone please help?

My latest attempt is this:

=COUNTIFS(A2:A200,"Paid",D2:D200,">0","<25"

I'm attempting to get a count for those cells between A2 and A200 that are shown as "Paid" along with any cells between D2 and D200 where the amount is more than £0 and less than £25. The spreadsheet that the COUNTIFS function is looking at has the D2:D200 section formatted as £ (so I'm looking at e.g £5, £10 etc). Will I need to put the £ sign in the COUNTIFS function too?

Many thanks for your help.
Jon

Thanks to all of you! I knew it would be a simple solution, but I just couldn't see the wood for the trees!