multiple formulas

  • Thread starter Thread starter mike
  • Start date Start date
M

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: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:D.. is this possible and if
so ...please god tell me how.

thanks
 
Try using SUM-IF

Example:

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

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

Example:

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

where E1=CDROM

I hope this leads you in the right direction...Jim
 
Jason, Jim and Chip

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

thanks for the replies...this newgroup actually works

mike
 
Back
Top