SumProduct Transposed????

[jxbeeman]

Hi,
I guess the best way to ask this would be with an example. (i was thinking
maybe a way to transpose the sumproduct formula)

jan feb mar apr may
data data data data data
data data data data data
1 1 2 1 1

What i'm looking to do is to sum up the #'s based on some criteria (more
than 1 criteria, so like data1 < 10 and maybe data2 = 5) in the same column.
so say the criteria was true for the feb and march column, i would want the
result to be --> 1 + 2 = 3.

Any Ideas would be greatly appreciated
Thanks,
Josh

 

[Bernard Liengme]

Assumptions:
Jan is in A1, Feb in B1 and this goes to Dec in L1
Row 2 holds data-1; row 3 holds data-2
Row 4 hold the amounts
Criteria for data-1 is in A10; so A10 =10
Criteria for data-2 is in B10; so B10 = 5
To get your answer use
=SUMPRODUCT(--(A2:L2<A10), --(A3:L3=B10), A4:L4)

Sumproduct works with columns or with rows
best wishes