#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"