Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Hi
0 views
Skip to first unread message
H.@discussions.microsoft.com Nat H.
Nov 12, 2009, 2:13:02 PM11/12/09
to
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.
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?
Mike H
Nov 12, 2009, 2:17:01 PM11/12/09
to
Hi,
This will return TRUE or FALSE
=SUM(A1:A5)=B1
Mike
Luizvs
Nov 12, 2009, 6:22:02 PM11/12/09
to
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!)
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!)
0 new messages