| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use more complex logical expression for sumif as creteria?
I want to use a more complex logical expression as creteria in SUMIF. For
example, sum number in the cell on column 6 when cell on column 1 is "MA" AND cell on column 2 is greater than 5000. I may use either "and" or "or" to connect the two tests. Is there an easy way to do that without creating an extra combined column (to make MA5001, MA12400, NH2300, etc.) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you determine if a field is blank in a logical expression. | Excel Discussion (Misc queries) | |||
| Can Excel represent formula in textural format with values substi. | Excel Worksheet Functions | |||
Threaded Mode
