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:
