RE: Find a particular Month in Row and then Sum Column if it meets a particular criteria

[tyrese215]

RE: Find a particular Month in Row and then Sum Column if it meets a particular criteria

I have the following table


[TABLE="width: 384"]
<tbody>[TR]
[TD][/TD]
[TD]Jan-18[/TD]
[TD]Feb-18[/TD]
[TD]Mar-18[/TD]
[TD]Apr-18[/TD]
[TD]May-18[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD] 1,639,212 [/TD]
[TD] 135 [/TD]
[TD] 1,639,212 [/TD]
[TD] 135 [/TD]
[TD] 135 [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD] 2,135,135 [/TD]
[TD] 24 [/TD]
[TD] 1,639,212 [/TD]
[TD] 642 [/TD]
[TD] 1,639,212 [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD] 1,639,212 [/TD]
[TD] 135 [/TD]
[TD] 1 [/TD]
[TD] 1,639,212 [/TD]
[TD] 5 [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD] 13 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[TD] 135 [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD] 1,639,212 [/TD]
[TD] 351 [/TD]
[TD] 3 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD] 35 [/TD]
[TD] 1 [/TD]
[TD] 35 [/TD]
[TD] 1,639,212 [/TD]
[TD] 35 [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[TD] 1,639,212 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Feb-18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]B[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="6"></colgroup>[/TABLE]






I need a formula in cell C14 that will find a particular date in row 1 that I have placed in cell B13, and then will sum that entire column of ALL values IF column A matches the value that I have in B14


Thank you VERY much

 

[Aladin Akyurek]

Re: Find a particular Month in Row and then Sum Column if it meets a particular criteria

Try...

=SUMIFS(INDEX($B$2:$F$8,0,MATCH(B13,$B$1:$F$1,0)),$A$2:$A$8,B14)