Criteria

R

Roger

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
 
S

Sam Wilson

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
 
J

Jacob Skaria

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count With Criteria 11
Counting on 2 criteria 2
Add SUMPRODUCTS with Multiple Criteria 14
Sum total using Sumproduct if two criteria met 5
Multiple Coumns Criteria 3
Summing Criteria with Index - Match 4
Summing cells based on mulitiple criteria over mulitple columns 1
SUMPRODUCT or COUNTIF - Multiple Criteria 2

Top