CODEWITHSUNDEEP
excelexcel-formula
William C.
William C.

Reputation: 212

Concat/Concatenate Error

All, I come before you with a puzzle that I cannot figure out.

I recently transitioned to Office 365 from 2010 and am having a world of difficulty adapting my formulas and scripts to work in the new platform.

Particularly, I am running into an issue where one of my SUM(IF(CONCATENATE formulas can no longer find data.

Previously, in 2010, I had a formula as follows:

{=SUM(IF(CONCATENATE(B8,C8,D8)=CONCATENATE(ProjectData!A2:A20000,ProjectData!C2:C20000,ProjectData!W2:W20000),ProjectData!T2:T20000))}

This formula would sum a range of numbers if 3 cells matched 3 cells in a range of data.

This no longer works in Office 2016.

Has any syntax changed that might be causing this error? Thanks in advance.

Upvotes: 0

Views: 57

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use SUMIFS()

=SUMIFS(ProjectData!T:T,ProjectData!A:A,B8,ProjectData!C:C,C8,ProjectData!W:W,D8)

Upvotes: 2

Related Questions