Hello all
On sheet2, I have setup a list of stores.
I want a formula in cell B2 to drag down which counts the number of non-blank cells from Sheet 1, column J, that match the retailer name in Sheet1 column A
So I guess it's a COUNTIFS but I don't know how to count up the non-blank cells (combine the two...)
i WAS TRYING SOMEthing like this: =COUNTIFS(Sheet1!J2:J51,<>"",Sheet2!A1,Sheet1!A2:A30))
Please can someone help? thank you
Bookmarks