sumif differentiate between 6.1 & 6.10

I'm using the sumif function to reference a separate worksheet and match item numbers for an estimate.

=SUMIF([DSQN_PS108_Estimate.xls]Summary!$C$206:$C$311,"="&(C302),[DSQN_PS108_Estimate.xls]Summary!$G$206:$G$311)

I want it to search the list and find the quantity for item number 6.1 & 6.10 (saved as text, '6.1 & '6.10). The formula ends up not differentiating between the two and returns them summed together.

Any ideas?

In the world of numbers, there is no difference between 6.1 and 6.10, they both have the same value.

The SUMIF funciton is coercing the text strings in column C to real numbers, 6.10 becomes 6.1

Try SUMPRODUCT Instead

=SUMPRODUCT(--([DSQN_PS108_Estimate.xls]Summary!$C$206:$C$311=C302),[DSQN_PS108_Estimate.xls]Summary!$G$206:$G$311)

I'm new to the sumproduct function. how would i write the formula if I wanted it to pass two qualifiers before it returns a value? Also, what do the two dashes represent in the beginning of your function?

It did work though! Thanks so much

Nevermind, figured out both

Thanks again for the help. You just saved me so much time

Cool, glad to help.