Sum Ifs of Concatenation

[robocop1906]

I know there is a better way to do this<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
=SUMIFS(J:J,CONCATENATE(B:B,L:L),CONCATENATE(B:B,L:L))<o></o>
<o> </o>
Trying to sum column J were the combination of B and L match. This works on a single column without the concate.<o></o>
<o> </o>
Thanks,<o></o>

 

[schielrn]

I'm not sure I am understanding what you are trying to accomplish here? The criteria1 part of the formula is only going to use the first value of a certain column? What do you mean it works with a single column? Can you maybe post some sample data what what you expect as a result?

 

[Scott Huish]

Is this what you need?

=SUMPRODUCT(--(B:B=L:L),J:J)

 

[robocop1906]

Column B:B contains resource names and columnL:L week periods which consist of 5 days/cells . So i'm trying to sum for say week of July 3 i.e. the period which has five business days. It's pretty much what a pivot table would do if I were to pivot the information.