| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumIf function
That example is rows.
Why don't you give a data example? -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Richard" wrote in message ... the information is on seperate rows not columns. Shouldn't SumIf work? Richard "VBA Noob" wrote: Hi Say Col A has part No. Col b has Loc 1, col C has Loc 2 then this formula should work =SUMPRODUCT(--(A2:A15="A")*(B2:B15)+(C2:C15)) VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561274 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
