Sumproduct Help

Hi,

I need some help with some product where it looks to find a unique number and returns it in the correct column based on the month.

e.g. in the red cells I would like a formula which looks up Z2, matches it with column M and then matches the month with column X.

Can anyone help?

Example attached

Paul

Hi,

Please try the following formula in AA2 and drag to the right.


=SUMPRODUCT(--($M:$M=$Z2),--($X:$X=AA$1),$T:$T)

Thanks - what does the -- do?

Using two minus signs in an Excel formula causes the formula to transform a result of “True” into a value of “1” and a result of “False” into a value of “0"

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Ahh! Thanks all