Which function do I use to count all of the rows that have both the
numberical value >0 in column C AND the words "Star quality" in Column L?
Which function do I use to count all of the rows that have both the
numberical value >0 in column C AND the words "Star quality" in Column L?
=SUMPRODUCT(--(C1:C100>0),--(L1:L100="Star quality"))
Adjusting ranges to suit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks