| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
FORMULAS please help
Hi there
I am trying to create a formula that refences < numbers in a columm then adds up the from a different columm i.e add b1:b100 only if a1:a100 is 10000 <12000 =46 a b 10000 32 9000 64 12001 86 11999 14 9990 12 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to cut and paste with locked formulas | Excel Discussion (Misc queries) | |||
| Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
