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

	Jan-18	Feb-18	Mar-18	Apr-18	May-18
A	1,639,212	135	1,639,212	135	135
A	2,135,135	24	1,639,212	642	1,639,212
A	1,639,212	135	1	1,639,212	5
B	13	1,639,212	1,639,212	1,639,212	135
B	1,639,212	351	3	1,639,212	1,639,212
B	35	1	35	1,639,212	35
C	1,639,212	1,639,212	1,639,212	1,639,212	1,639,212
	Feb-18
	B

<tbody>
</tbody><colgroup><col span="6"></colgroup>

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)