## Friday, January 18, 2013

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

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 18, 2013
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?:

=COUNTIF(Sheet1!E2:E750;"NNN")
=COUNTIF(Sheet1!S2:S750;3600)
------------------------------------------------------------------------------------------

following is a solution to the problem