How to countifs a row of value + a fixed value?

[bjorng]

Hello,

I want to count a row of values PLUS a specific value, if they together are greater than my criteria. I cant add an extra column where I do the first step of adding, I want to do it in one formula. Is this possible?

I tried COUNTIFS('Stage1_Date+FixedValue, "<="&2014/12/31,Country,Brazil), which does not work.

Thank you,
Bjorn

[Tony Valko]

Maybe this...

A1 = 2014/12/31
B1 = Brazil

=SUMPRODUCT(--(Stage1_Date+FixedValue<=A1),--(Country=B1))