| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with two conditions?
How to use "sumif" funtion in which there are tow criteria? A B 10 1 13 2 15 3 20 12 I want calculation col B with criteria col A 10, <15. Who help me? -- thiensu ------------------------------------------------------------------------ thiensu's Profile: http://www.excelforum.com/member.php...o&userid=36317 View this thread: http://www.excelforum.com/showthread...hreadid=560967 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with two conditions?
Thiensu
=SUMPRODUCT((A1:A410)*(A1:A4<15)*(B1:B4)) adjust the range to suit Regards Trevor "thiensu" wrote in message ... How to use "sumif" funtion in which there are tow criteria? A B 10 1 13 2 15 3 20 12 I want calculation col B with criteria col A 10, <15. Who help me? -- thiensu ------------------------------------------------------------------------ thiensu's Profile: http://www.excelforum.com/member.php...o&userid=36317 View this thread: http://www.excelforum.com/showthread...hreadid=560967 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with 2 conditions | Excel Worksheet Functions | |||
| SUMIF function with 2 conditions | Excel Worksheet Functions | |||
| SUMIF with two conditions | Excel Discussion (Misc queries) | |||
| sumif with two conditions | Excel Worksheet Functions | |||
| SUMIF based on 2 conditions | Excel Worksheet Functions | |||
Linear Mode
