Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Hi,
My spreadsheet contains 3 columns. A - product code (numerical 1 - 10000) B - product description C - price I need a formula to achieve the following... - any product codes (A) between eg 1-499 i want to add the amount (C) for each of the products in this range. In other words I want the formula to lookup column A, and any number found here that's between 1 - 499 add the corresponding value in column C. Hope that makes sense. Any suggestion greatly appreciated. Cheers, B1888 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Hi
One way =SUMIF(A:A,"<500",C:C) -- Regards Roger Govier "b1888" wrote in message oups.com... Hi, My spreadsheet contains 3 columns. A - product code (numerical 1 - 10000) B - product description C - price I need a formula to achieve the following... - any product codes (A) between eg 1-499 i want to add the amount (C) for each of the products in this range. In other words I want the formula to lookup column A, and any number found here that's between 1 - 499 add the corresponding value in column C. Hope that makes sense. Any suggestion greatly appreciated. Cheers, B1888 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Hi Roger,
thats great thanks! just one further question - if I now want to do the same with anything between 500 - 999 how do I tell the formula to look between 500 - 999 rather than just <1000 as I want to exclude anything lower than 500. Thanks again, B Roger Govier wrote: Hi One way =SUMIF(A:A,"<500",C:C) -- Regards Roger Govier |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
=SUMIF(A:A,"<100",C:C)-SUMIF(A:A,"<500",C:C)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "b1888" wrote in message ups.com... Hi Roger, thats great thanks! just one further question - if I now want to do the same with anything between 500 - 999 how do I tell the formula to look between 500 - 999 rather than just <1000 as I want to exclude anything lower than 500. Thanks again, B Roger Govier wrote: Hi One way =SUMIF(A:A,"<500",C:C) -- Regards Roger Govier |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Hi
You need to use 2 Sumif's taking away the values included in the lower section =SUMIF(A:A,"<1000",C:C)-SUMIF(A:A,"<500",C:C) -- Regards Roger Govier "b1888" wrote in message ups.com... Hi Roger, thats great thanks! just one further question - if I now want to do the same with anything between 500 - 999 how do I tell the formula to look between 500 - 999 rather than just <1000 as I want to exclude anything lower than 500. Thanks again, B Roger Govier wrote: Hi One way =SUMIF(A:A,"<500",C:C) -- Regards Roger Govier |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
oops
=SUMIF(A:A,"<1000",C:C)-SUMIF(A:A,"<500",C:C) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Bob Phillips" wrote in message ... =SUMIF(A:A,"<100",C:C)-SUMIF(A:A,"<500",C:C) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "b1888" wrote in message ups.com... Hi Roger, thats great thanks! just one further question - if I now want to do the same with anything between 500 - 999 how do I tell the formula to look between 500 - 999 rather than just <1000 as I want to exclude anything lower than 500. Thanks again, B Roger Govier wrote: Hi One way =SUMIF(A:A,"<500",C:C) -- Regards Roger Govier |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
Bob,
that'll do the trick. cheers, B Bob Phillips wrote: =SUMIF(A:A,"<100",C:C)-SUMIF(A:A,"<500",C:C) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula - help needed!
cheers Roger
Roger Govier wrote: Hi You need to use 2 Sumif's taking away the values included in the lower section =SUMIF(A:A,"<1000",C:C)-SUMIF(A:A,"<500",C:C) -- Regards Roger Govier |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions |