Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 02:00 AM posted to microsoft.public.excel.worksheet.functions
statusquo
 
Posts: n/a
Default Comparing One Range and Adding Another


Hi,

For one of my sheets, I need to sum all the values in A1:A10 for which
the corresponding value in B1:B10 is less than 30. For example

A B
2 40
5 20
10 50
20 10

Would equal 25 (A2+A4 because B2 and B4 are both less than 30, but B1
and B3 are not).

Thanks!


--
statusquo
------------------------------------------------------------------------
statusquo's Profile: http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492058


  #2   Report Post  
Old December 9th 05, 02:16 AM posted to microsoft.public.excel.worksheet.functions
ScottO
 
Posts: n/a
Default Comparing One Range and Adding Another

Take a look at the SUMIF function.
Rgds,
ScottO

"statusquo"
wrote in message
...
|
| Hi,
|
| For one of my sheets, I need to sum all the values in A1:A10 for
which
| the corresponding value in B1:B10 is less than 30. For example
|
| A B
| 2 40
| 5 20
| 10 50
| 20 10
|
| Would equal 25 (A2+A4 because B2 and B4 are both less than 30, but
B1
| and B3 are not).
|
| Thanks!
|
|
| --
| statusquo
| -------------------------------------------------------------------
-----
| statusquo's Profile:
http://www.excelforum.com/member.php...o&userid=29501
| View this thread:
http://www.excelforum.com/showthread...hreadid=492058
|


  #3   Report Post  
Old December 9th 05, 02:37 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default Comparing One Range and Adding Another

=SUMIF(B1:B10,"<30",A1:A10)


Gord Dibben Excel MVP


On Thu, 8 Dec 2005 19:00:02 -0600, statusquo
wrote:


Hi,

For one of my sheets, I need to sum all the values in A1:A10 for which
the corresponding value in B1:B10 is less than 30. For example

A B
2 40
5 20
10 50
20 10

Would equal 25 (A2+A4 because B2 and B4 are both less than 30, but B1
and B3 are not).

Thanks!

  #4   Report Post  
Old December 9th 05, 02:54 AM posted to microsoft.public.excel.worksheet.functions
statusquo
 
Posts: n/a
Default Comparing One Range and Adding Another


Thank you, that worked perfectly.


--
statusquo
------------------------------------------------------------------------
statusquo's Profile: http://www.excelforum.com/member.php...o&userid=29501
View this thread: http://www.excelforum.com/showthread...hreadid=492058



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help: Adding an equation to a range tobriant Excel Worksheet Functions 2 August 25th 05 06:40 PM
adding the same prefix or suffix to a range of cells Betty Turvy Excel Discussion (Misc queries) 5 July 12th 05 05:13 PM
adding occurrences for date range Mike Excel Discussion (Misc queries) 1 April 28th 05 09:14 PM
Adding contents of one cell to a range of cells. CLJinVA Excel Worksheet Functions 1 February 10th 05 11:19 PM
Adding to a range in a reference? LilaDuncan New Users to Excel 2 February 7th 05 04:12 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017