Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi
I have a column full of 150 amounts or more. I need to know if the sum of
some of these amounts equal a specific amount which I have determined. example: let's say I have in A1 thru A5 2,4,5,3,12 and I want to determine if the sum of any of these 5 amounts equals 8 (B1). What would be the formula, function to input? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi
Hi,
This will return TRUE or FALSE =SUM(A1:A5)=B1 Mike "Nat H." wrote: I have a column full of 150 amounts or more. I need to know if the sum of some of these amounts equal a specific amount which I have determined. example: let's say I have in A1 thru A5 2,4,5,3,12 and I want to determine if the sum of any of these 5 amounts equals 8 (B1). What would be the formula, function to input? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi
If you are talking about combinations, meaning putting some cells together,
there is no formula for that. Only with macros you can do that and it is not easy, because you will have to think about multiple solutions (how choose if you have more than 1 solution!) "Nat H." wrote: I have a column full of 150 amounts or more. I need to know if the sum of some of these amounts equal a specific amount which I have determined. example: let's say I have in A1 thru A5 2,4,5,3,12 and I want to determine if the sum of any of these 5 amounts equals 8 (B1). What would be the formula, function to input? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|