Type this:

=SUM(IF(A1:A100-INT(A1:A100)0.88,B1:B100,0))

but use Ctrl + Shift + Enter rather than just enter after you've typed it.

Sam

"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