We help IT Professionals succeed at work.

How to write sumifs function in Office XP

Dear all experts,

I'm using Office 2010 and I know there is a function called sumifs which is used to for calculation, however my company is using Office XP and wonder is there any similar thing of it?  Or, is there any VBA code that can serves similar thing?

Thanks in advance,
Comment
Watch Question

You can use SUMPRODUCT formula. If you can provide an example, I can show.

http://office.microsoft.com/en-us/excel-help/sumproduct-HP005209293.aspx
Most Valuable Expert 2012
Top Expert 2012
Commented:
Here's a practical example:

=SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2,criteria_range3,criteria)

The equivalent SUMPRODUCT would be:

=SUMPRODUCT((sum_range)*(criteria_range1=criteria1)*(criteria_range2=criteria_range2)*(criteria_range3=criteria3))

As with SUMIFS, you can keep adding criteria comparisons with SUMPRODUCT as well.

Cheers,

Dave

Explore More ContentExplore courses, solutions, and other research materials related to this topic.