Thankyou for your suggestions - I will have a play

"Roger" wrote:

The function below works
Answer = .SumIfs(Range("B1:B100"),Range("A1:A100"),"300")

Criteria Column Column To Sum
£233.56 £5000
£266.89 £6000
£455.91 £8000
etc

Answer = £6000

How would I write the criteria to sum entries where the adjacent value ends
in 88p or more - I have tried many different ways using wils cards etc but
none of them work. Thankyou in anticipation