| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Criteria
The function below works
Answer = .SumIfs(Range("B1:B100"),Range("A1:A100"),"300") Criteria Column Column To Sum £233.56 £5000 £266.89 £6000 £455.91 £8000 etc Answer = £6000 How would I write the criteria to sum entries where the adjacent value ends in 88p or more - I have tried many different ways using wils cards etc but none of them work. Thankyou in anticipation |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| have input box. Need criteria entered to refer to cond. format criteria | Excel Programming | |||
Threaded Mode
