Sumifs+index formula help!!

[WormJacob]

Hello ,

NEw to this forum and would to get help(first thank you in advanced)!!

I need help to create a formula that sum the following Summary below?

[TABLE="width: 1023"]
<colgroup><col><col><col><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[WormJacob]

Hi Eric,

Copied and paste but it still giving m ZERO???

=SUMPRODUCT(('FRC-Jan18'!$E$2:$BB$103)*('FRC-Jan18'!$C$2:$C$103=C$3)*(YEAR('FRC-Jan18'!$E$1:$BB$1)=$C$1)*(TEXT('FRC-Jan18'!$E$1:$BB$1,"mmm")=INDEX($C$2:$Y$2,FLOOR(COLUMNS($C2:C2)-1,2)+1))*('FRC-Jan18'!$A$2:$A$103=$A4))


THank you

 

[Eric W]

How many cells did you paste it into? Based on the small sample you posted, the answer for C4 IS zero. If you entered the formula in C4, then copied C4 and pasted it to the range, and there's a cell in that range that you can verify should not be zero, let me know.

 

[WormJacob]

I copied the formula you gave on C4 then dragged them down and accross.. All zero-((

 

[WormJacob]

Hi Eric..

Problem Solved.. Found the issues.. GReat Help!! Thank you!

Thanks