SUMIF on 1 row and 2 column criteria

[csherman7992]

My data looks like this:

		Jan	Feb	Mar	Apr
A	AA	5	6	7	8
A	AB	9	10	11	12
B	BA	13	14	15	16
B	BB	17	18	19	20
C	CA	21	22	23	24
C	CB	25	26	27	28

<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>

I want to be able to sum all data in Row "X" that happens before Mar (based on header row). The row I want to sum is based on the criteria in the first two columns (ie sum the row that has "B" in column A and "BB" in column c).

How would I go about doing this?

 

[godsaaint]

How do you have the months formatted? Are they formatted as text and you type, "Jan", "Feb", etc?

EDIT:

You could do something like this as long as your months are formatted as date:

Formula in D11(SUM), confirm with CTRL-SHIFT-ENTER: =

SUMIFS(INDEX(C2:F7,MATCH(D12&D13,A2:A7&B2:B7,0),0),C1:F1,"<"&D14)

		ene-16	feb-16	mar-16	abr-16
A	AA	5	6	7	8
A	AB	9	10	11	12
B	BA	13	14	15	16
B	BB	17	18	19	20
C	CA	21	22	23	24
C	CB	25	26	27	28
		SUM	19
		1st Criteria	A
		2nd Criteria	AB
		Before	mar-16

<tbody>
</tbody>

 

[csherman7992]

No. They're formatted 1/1/17, 2/1/17, etc.

 

[godsaaint]

No. They're formatted 1/1/17, 2/1/17, etc.

The solution I provided should work then. Just wanted to confirm you were using any kind of excel date format, and not text.

 

[Tetra201]

No. They're formatted 1/1/17, 2/1/17, etc.

Try the following formula (to be entered using Ctrl+Shift+Enter, not just Enter):

=SUMIF(C1:F1,"<"&"2017-3-1",INDEX(C1:F9,MATCH("B"&"BB",A1:A9&B1:B9,0),0))

 

[csherman7992]

That's the one. Thanks!

 

[Tetra201]

You are welcome.