| 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 ?? |
|
#2
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)*('13b'! H3:H75<=93),('13b'!F3:F75),"")) as an array formula or (not an array formula) either =SUMPRODUCT(('13b'!A3:A75="Customer 1")*('13b'!C3:C75="QAR")*('13b'!H3:H7531)*('13b'! H3:H75<=93)*('13b'!F3:F75)) or =SUMPRODUCT(--('13b'!A3:A75="Customer 1"),--('13b'!C3:C75="QAR"),--('13b'!H3:H7531),--('13b'!H3:H75<=93),('13b'!F3:F75)) -- David Biddulph "Sam" wrote in message ... =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 ?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple range in SUM,IF
=SUMPRODUCT(('13b'!A3:A75="Customer1")*('13b'!C3:C 75="QAR")*('13b'!H3:H7531)*('13b'!H3:H75<=93),('1 3b'!F3:F75)) Check whether the A3:A75 criteria is "Customer1" or "Customer 1". If it is Customer 1 then change the A3:A75 criteria in the formula also. Since there was an unfortunate Paragraph Mark in your post, so I could not able to identify. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Sam" wrote: =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 ?? |
| Reply |
| 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 | |||
Linear Mode
