Kumar -
Apr 4, 2012 at 07:21 AM - Latest reply: rizvisa14481
Posts Thursday January 28, 2010Registration dateContributorStatus
January 6, 2016
Last seen
- Apr 10, 2012 at 07:34 PM
Sir
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.
Sir
It is not "Sumif" i need for "Sumifs". I will explain you my problem.
Ex:
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.
With regards
Kumar
