Sumifs in Excel 2003 [Solved/Closed]

Kumar - Apr 4, 2012 at 07:21 AM - Latest reply: rizvisa1 4481 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.

Kumar
See more 

7 replies

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 4, 2012 at 06:20 PM
0
Thank you
I do believe that excel 2003 had sumif too
0
Thank you
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
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 5, 2012 at 05:23 AM
I have a feeling that you have to work with SUMPRODUCT function or even array formula
0
Thank you
Sir
Can you help me in sum product function.

Kumar
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 7, 2012 at 07:07 AM
it is like this

=SUMPRODUCT(((first criteria range here)="criteria 1) *((2nd criteria range here)="criteria 2) * (sum range here)* 1)
0
Thank you
Sir

Thanks for the Guidance. The function is working. I once again thank you for the help.

With regards
Kumar
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 10, 2012 at 07:34 PM
You are quite welcome. Good luck