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     www.energyefficientbuild.com.    Jan 18, 2013
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?:

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

following is a solution to the problem

No comments:

Post a Comment