Sumifs in Excel 2003 [Solved/Closed]

Report
-
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
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

4 replies

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
I do believe that excel 2003 had sumif too
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
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
I have a feeling that you have to work with SUMPRODUCT function or even array formula
Sir
Can you help me in sum product function.

Kumar
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
it is like this

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

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

With regards
Kumar
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
758
You are quite welcome. Good luck