| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple range in SUM,IF
=SUM(IF(('13b'!A3:A75="Customer
1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531<=93),('1 3b'!F3:F75),"")) Im above array formula, 3rd criteria i am trying to set range 31 AND <=93 but it doesnt work .. could anyone help ?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Counting from one range to another range, multiple criteria | Excel Discussion (Misc queries) | |||
| Want to use a range name on multiple sheets | Excel Discussion (Misc queries) | |||
| multiple range | Excel Discussion (Misc queries) | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Threaded Mode
