If you mean the entries in Col A are =0.88 then try

=SUMPRODUCT(--(A2:A4=0.88),B2:B4)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Hi Roger

Try the below....But what about whole numbers...eg: 266.00

Criteria Column Column To Sum
$233.50 $5,000.00
$266.88 $6,000.00
$455.88 $8,000.00

=SUMPRODUCT(--(TEXT(MOD(A2:A4,1)*100,"00")+0=88),B2:B4)

If this post helps click Yes
---------------
Jacob Skaria


"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