| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum cells with criteria
I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead of
the constant 5 in the criteria I want to use a variable, means the value of the cell C1. How can i DO IT? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Print cells that meet conditional formatting criteria | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Threaded Mode
