![]() |
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 |
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 |
All times are GMT +1. The time now is 03:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com