Sumifs in Excel 2003 [Solved/Closed]

- - Latest reply: rizvisa1
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- 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 

4 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
You are quite welcome. Good luck