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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks