View Single Post
  #1   Report Post  
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