With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, January 18, 2013
yogi_Count In Sheet2 Number of Records That Meet Multiple Criteria For A Table in Sheet1
user Malonemjm said:(http://productforums.google.com/forum/?zx=tzjioh867rof#!category-topic/docs/spreadsheets/d6L5kE1Er-Q) Count Records with Multiple Criteria from different sheet I've seen some similar questions asked but still can't figure out what formula to utilize.
From Sheet 2 in a spreadsheet I'm trying to count the number of records in Sheet 1 that match two criteria:
1 - If value string in column E="NNN" (this is my first filter to find the subset of data I'm interested in - values are alpha strings)
2 - If $$ value in column S="$$" (once I have the subset from above, I want to know how many meet this 2nd criteria which is a number value)
A Simple Countif (examples below) will return me the number of records that match one of those criteria, but how do I construct a formula that will return me a count of records that match both criteria?: