Hi All,
I am trying to get the following formula to work, but its returning a zero.
=COUNTIFS(D3:D2713,"Red",$AB$3:$AB$2713,">=-2.50", $AB$3:$AB$2713,"<=-0.99")
I want the formula to count the amount of cases that fall in between the costing criteria listed below?
<tbody>
</tbody>
Cheers
I am trying to get the following formula to work, but its returning a zero.
=COUNTIFS(D3:D2713,"Red",$AB$3:$AB$2713,">=-2.50", $AB$3:$AB$2713,"<=-0.99")
I want the formula to count the amount of cases that fall in between the costing criteria listed below?
Charge Criteria (£) | Formula?? |
-£2.51+ | |
-£2.50 - -£0.99 | |
£0.00 - £2.50 | |
£2.51 - £5.00 | |
£5.01 - £7.50 | |
£7.51 - £10.00 | |
£10.01 - £12.50 | |
£12.51+ |
<tbody>
</tbody>
Cheers
Last edited: