| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif - multiple criteria
If this is a sample of my spreadsheet, how do I calculate so that the results
will look at both col A and B and sum the total in col C for each variable in col. A. In other words what is the total amount for A for Jan, Mar... Col A Col B Col C Col D a Mar 254 850 a Jan 266 125 c Feb 987 121 c Jan 885 151 a Mar 352 850 b Jan 558 454 Thanks, Anat |
|
#2
|
|||
|
|||
|
A pivot table would give you the desired results.
-- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "Anat" wrote in message ... If this is a sample of my spreadsheet, how do I calculate so that the results will look at both col A and B and sum the total in col C for each variable in col. A. In other words what is the total amount for A for Jan, Mar... Col A Col B Col C Col D a Mar 254 850 a Jan 266 125 c Feb 987 121 c Jan 885 151 a Mar 352 850 b Jan 558 454 Thanks, Anat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Can I use multiple criteria in SUMIF funqtion? | Excel Worksheet Functions | |||
| SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
| How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Linear Mode
