sumproduct

[Subhash Sarker]

I want to make summation of some values in the column T avoiding the values for which corresponding cells in column B is blank.
I am trying with the formula below but is does not work

=SUMPRODUCT((T$5:OFFSET(T$127,-1,))*(C$5:OFFSET(C$127,-1,))=N132*(B$5:OFFSET(B$127,-1,)<>""))

Please help

Subhash

[icestationzbra]

at first glance, i see that you have not used parentheses to separate segments properly.

=SUMPRODUCT((T$5:OFFSET(T$127,-1,))* ( (C$5:OFFSET(C$127,-1,))=N132 ) * (B$5:OFFSET(B$127,-1,)<>""))

see if that solves the problem...