LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
boogie
 
Posts: n/a
Default ADDING CELLS WHICH ARE <> THAN OTHER CELLS

I am trying to formulate a formula or macro.
Cells A1:A10 if greater than 8000 add figure in B1:B10
a1 = 8015 b1 = 1000
a2 = 7999 b2 = 1000
a3 = 8066 b3 = 4
a4 = 6000 b4 = 28
the answer i need will be 1004

Thanks heaps who ever can help me
 
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
Adding contents of cells by clicking in Excel 2002 Kevin Gordon Excel Discussion (Misc queries) 7 January 11th 05 04:49 PM
Adding formatted cells to an outline ? Glenn Excel Discussion (Misc queries) 4 January 11th 05 04:10 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Excel Discussion (Misc queries) 4 December 21st 04 04:44 AM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM
Adding cells with numbers and text EddieZ Excel Worksheet Functions 4 November 9th 04 12:43 PM


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