Friday, January 18, 2013

yogi_Count In Sheet2 Number of Records That Meet Multiple Criteria For A Table in Sheet1

                                          Google Spreadsheet  Post  #978
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 18, 2013
user Malonemjm said:(!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?:


following is a solution to the problem