Hi All,

Is it possible to use concatenation with multiple sumif?

I have the following formula but it doesn't work with the concatenation, any
suggestion of what I'm doing wrong

Thanks in advance for any help


=SUM(IF((tblProcessorActivity!$B$1:$B$2999="CG")*( tblProcessorActivity!$N$1:$N$2999=(MONTH(MAX(tblPr ocessorActivity!$C:$C))&RIGHT('Processor
Time Allocation'!B$6,1))),tblProcessorActivity!$D$1:$D$ 2999))