#1   Report Post  
boogie
 
Posts: n/a
Default Help with a formula

Hi there
I need help with a formula
The formula I need is probaly very simple.
If cell a1:a55 is 8000 but <12000 add the cells in B1:b55
eg
a1 10000 b1 525
a2 8050 b2 500
a3 12500 b3 628
the answer would be 1025
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

A couple of ways

=SUMIF(A1:A55,"8000",B1:B55)-SUMIF(A1:A55,"=12000",B1:B55)

=SUMPRODUCT(--(A1:A558000),--(A1:A55<12000),B1:B55)

having said that, didn't you post the same question some time ago?

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"boogie" wrote in message
...
Hi there
I need help with a formula
The formula I need is probaly very simple.
If cell a1:a55 is 8000 but <12000 add the cells in B1:b55
eg
a1 10000 b1 525
a2 8050 b2 500
a3 12500 b3 628
the answer would be 1025



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
formula help Bill H. Charts and Charting in Excel 2 January 2nd 05 06:26 AM
New formula: = does not disappear Mike Excel Discussion (Misc queries) 3 December 6th 04 02:37 AM
Aligning Two Lists in Excel Rich Excel Discussion (Misc queries) 2 December 4th 04 06:44 PM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 12:29 PM
hyperlink formula David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 06:32 PM


All times are GMT +1. The time now is 01:28 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"