I was using System with office 2010 and deriving some values by using "Sumifs" function. Now i am using Office 2003 system. When i copied the workbook to Office 2003 System, I am not bale do "Sumifs" function in 2003 System. I will be great full if any body help me in suggesting corresponding function in Excel 2003.
It is not "Sumif" i need for "Sumifs". I will explain you my problem.
Month Description Amount
Jun-11 Salary Paid 200
jun-11 TA Bill paid 150
Jun-11 Salary Paid 100
Jul-11 TA Bill paid 50
Jul-11 conveyance paid 25
Jul-11 TA Bill Paid 125
From the above data i want totals of salary paid in jun-11
then I want totals of TA paid in Jul-11
I was using Excel 2010 and deriving values with function "Sumifs". Now i want same results in Excel 2003.