| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special SUMIF Formula
In om, shaqil
spake thusly: Name Amount A-B 10 AB 20 B-A 10 I need sum of those who has "-" in their name i.e A-B and B-A. One way: =SUMIF(A:A,"*-*",B:B) Kindly do the needful. :-) =dman= |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating a special formula | New Users to Excel | |||
| Paste Special Formula | Excel Worksheet Functions | |||
| special case of sumif | Excel Worksheet Functions | |||
| special sum formula | Excel Worksheet Functions | |||
| Special Formula | Excel Programming | |||
Threaded Mode
