Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (embedded if???)
I need help with a sumif. This is what i have: Column B (range 1:5) has
numbers. I would like a formula to say if the numbers are greater than 256, then add the number greater than 256 minus 256 and then produce a sum of the "excess". A B 1 5 2 10 3 300 4 258 5 500 6 7 **** = this should come up with 290 (300-256=44; 500-256=244;258- 256=2 **so far i have =sumif(B1:B5,"256", Thanks for your help in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (embedded if???)
Look at SUMPRODUCT.
Here's more info: http://www.meadinkent.co.uk/xlsumproduct.htm -- Brevity is the soul of wit. "Daniel Q." wrote: I need help with a sumif. This is what i have: Column B (range 1:5) has numbers. I would like a formula to say if the numbers are greater than 256, then add the number greater than 256 minus 256 and then produce a sum of the "excess". A B 1 5 2 10 3 300 4 258 5 500 6 7 **** = this should come up with 290 (300-256=44; 500-256=244;258- 256=2 **so far i have =sumif(B1:B5,"256", Thanks for your help in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (embedded if???)
Try this:
=SUMIF(B1:B5,"256")-(COUNTIF(B1:B5,"256")*256) "Daniel Q." wrote: I need help with a sumif. This is what i have: Column B (range 1:5) has numbers. I would like a formula to say if the numbers are greater than 256, then add the number greater than 256 minus 256 and then produce a sum of the "excess". A B 1 5 2 10 3 300 4 258 5 500 6 7 **** = this should come up with 290 (300-256=44; 500-256=244;258- 256=2 **so far i have =sumif(B1:B5,"256", Thanks for your help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) |