Translation of SUMIFS Excel 2007 Formula to an Excel 2003 compatible formula

Lambrix

Board Regular
Joined
Jun 29, 2012
Messages
62
I am trying to translate the following formula into an array that will have the same function, but will be cross compatible with all versions of Excel. From what I have read online, you need to create an array in order to accomplish this. Does anybody know how to translate the formula below? I have added two examples of the same formula.

=SUMIFS('SharePoint List Inputs'!E:E,'SharePoint List Inputs'!C:C,"June",'SharePoint List Inputs'!F:F,"IDT")

=SUMIFS(E:E,C:C,"June",F:F,"IDT")
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,457
Office Version
  1. 365
Platform
  1. Windows
Code:
=sumproduct(E1:E1000,--(C1:C1000="June"),--(F1:F1000="IDT"))

Note: you cannot use absolute column references with sumproduct in XL2003
 

Watch MrExcel Video

Forum statistics

Threads
1,118,167
Messages
5,570,587
Members
412,327
Latest member
KLichter
Top