multiple formulas

[mike]

HELP!!!!

I am trying to find a way to integrate a sort and sum
function. Or something that will give me the same
result. Example could be an invoice..with multiple
products but with the same name...is there a way to take
an excel speadsheet formula and have it search for a
certain string of characters in A:A and then add up ONLY
their total costs from field D? the problem is that
there are other values in the sheet and i need it to be
able to add only the ones that match the set of characters
that i say. Like say i want only CDROM...i want it to
search for all of the CDROM entries in A:A and then add
up their costs from D.. is this possible and if
so ...please god tell me how.

thanks

 

[Jason Morin]

=SUMIF(A:A,"*CDROM*",D)

HTH
Jason
Atlanta, GA

 

[Jim]

Try using SUM-IF

Example:

=SUM(IF((Sheet1!A1:A100="CDROM",Sheet1!D1100)))

Note: "CDROM" could be changed to a cell reference

Example:

=SUM(IF((Sheet1!A1:A100=$E$1,Sheet1!D1100)))

where E1=CDROM

I hope this leads you in the right direction...Jim

 

[mike]

Jason, Jim and Chip

thanks for the suggestion...it worked thank god.

thanks for the replies...this newgroup actually works

mike