Spent a couple of very frustrating hours this morning messing with a spreadsheet that kept coming up with a #VALUE error. Tried everything. Absolutely had to make it work. Finally, RTFM.
Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.
Thank-you Microsoft. I knew that. What I didn’t was that I has screwed up a range name. All was well. Just in time for my Zoom yoga class, which was lots better knowing that my spreadsheet would indeed provide the required counts.
Now actually, in Hawai’i “two scoop rice and one scoop macaroni salad” is the base of our famous “plate lunch” – beloved by everyone including President Obama. But, this is not Hawai’i and that is not “plate lunch”.