| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if with a list as criteria
Here's one way
=SUM((A1:A20=TRANSPOSE(MyList))*(B1:B20)) with the list called MyList, needs to be entered with ctrl + shift & enter -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Matizka" wrote in message ... Hi, I need to sum all of the values for columns that are called: :A, B, C, D. I would like to use something like "in list " operand that are in some othe programs. How should I write it? Sorry if it is an obvious or recently asked questions I did some search on the forum but I haven't found an answer. Thanks in advance, M. -- Matizka ------------------------------------------------------------------------ Matizka's Profile: http://www.excelforum.com/member.php...o&userid=24098 View this thread: http://www.excelforum.com/showthread...hreadid=519723 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add to a cell on a list based on two criteria | New Users to Excel | |||
| data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Threaded Mode
