Sumifs in Excel 2003 Solved/Closed

Question

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.

Kumar

rizvisa1 · Answer

I do believe that excel 2003 had sumif too

Kumar · Answer

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

kumar · Answer

Sir
Can you help me in sum product function.

Kumar

kumar · Answer

Sir

Thanks for the Guidance. The function is working. I once again thank you for the help.

With regards
Kumar

Sumifs in Excel 2003

4 responses

Similar discussions

Subscribe To Our Newsletter!