SUM Array formula

[johns99]

Hello,

I am currently using an array formula to pull the sum of two columns based on two separate criteria:

{=SUM((details!$T$3:$T$1724+details!$V$3:$V$1724)*(EEID='C&B - Compensation Data'!$A3))}

This approach is currently working FYI.

The concern with the above formula is if the details are sorted it then throws the formula off, so I am looking to replicate the above without the possibility of the formula being deterred. I'm thinking a SUMIFS but I'm not sure how to do this with 2 whole columns.

Thanks in advance.

John

 

[johns99]

This worked, thank you much!

 

[jasonb75]

I'm thinking a SUMIFS but I'm not sure how to do this with 2 whole columns.

With the fix for the original problem, sumif might still be preferable.

=SUMIFS(details!$T$3:$T$1724,EEID,$A3)+SUMIFS(details!$V$3:$V$1724,EEID,$A3)

 

[johns99]

With the fix for the original problem, sumif might still be preferable.

=SUMIFS(details!$T$3:$T$1724,EEID,$A3)+SUMIFS(details!$V$3:$V$1724,EEID,$A3)

Great workaround, thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.
As you have 365, this should be faster

=SUM(FILTER(details!$T$3:$T$1724+details!$V$3:$V$1724,EEID=$A3))

 

[johns99]

Thank you @Fluff!