SUMIF Issue

I can't think logically today so please help me out

EIU 100% K-7438-95 $216,800
7-0 Electric 95% K-7442-63 $7,826
River constr. 0% K-7652 $135,750


Whereas:
LS=A1
EIU=B1
100%=C1
$216,800= D1

I want to take the amount in D1 if C1 =100% and make a year to date total

Hi,
could you post a sample of your data? It would be easier to see what you mean ( use the Manage Attachments button on the Reply to Thread form)

Cheers

Here ya go. Thank you

I want to take the amount in D1 if C1 =100% and make a year to date total

In your example percentage is in col A and amount in C. Is this correct?
On the other hand there is no date anywhere, so a simple sumif function should do.