Previous Topic Next Topic

Sumifs in Excel 2003

[Solved/Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 -
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

Answer 1 / 4
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
I do believe that excel 2003 had sumif too
Answer 2 / 4

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
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
I have a feeling that you have to work with SUMPRODUCT function or even array formula
Answer 3 / 4

Sir
Can you help me in sum product function.

Kumar
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
it is like this

=SUMPRODUCT(((first criteria range here)="criteria 1) *((2nd criteria range here)="criteria 2) * (sum range here)* 1)
Answer 4 / 4

Sir

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

With regards
Kumar
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
You are quite welcome. Good luck
Ask a question