What formula to use?:Sum column W if column Q equals 390 & column L equal McL

Sum column W if column Q equals 390 & column L equal McL

=SUMPRODUCT(W1:W100,(Q1:Q100=390)*(L1:L100="McL"))

I think this is what you need.

"Carolyn" wrote:

> Sum column W if column Q equals 390 & column L equal McL

Thanks!

"Sloth" wrote:

> =SUMPRODUCT(W1:W100,(Q1:Q100=390)*(L1:L100="McL"))
>
> I think this is what you need.
>
> "Carolyn" wrote:
>
> > Sum column W if column Q equals 390 & column L equal McL