Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Adding cells with numbers and text | Excel Worksheet Functions |