Convert COUNTIFS function from 2007 to something in 2003 version
in [General]
|
Prev: making a comment/description area in middle of form template
Next: Copying multiple cells out of multiple worksheets at same time.
From: cbrannlayt on 2 Apr 2010 14:47 I have this function in 2007 version, but need to make it work in 2003. What function would be compatible? =COUNTIFS('Cancel Detail First 60 Days'!$B$1:$B$163,"GGL",'Cancel Detail First 60 Days'!$I$1:$I$163,"UW")
From: JLatham on 2 Apr 2010 14:56 Try =SUMPRODUCT(--('Cancel Detail First 60 Days'!$B$1:$B$163="GGL"),--('Cancel Detail First 60 Days'!$I$1:$I$163="UW")) You can test it by putting it into your 2007 workbook next to your SUMIFS() formula,should give the same results. "cbrannlayt" wrote: > I have this function in 2007 version, but need to make it work in 2003. What > function would be compatible? > > =COUNTIFS('Cancel Detail First 60 Days'!$B$1:$B$163,"GGL",'Cancel Detail > First 60 Days'!$I$1:$I$163,"UW") > >
From: Mike H on 2 Apr 2010 14:56
Hi, This works in both =SUMPRODUCT(('Cancel Detail First 60 Days'!$B$1:$B$163="GGL")*('Cancel Detail First 60 Days'!$I$1:$I$163="UW")) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "cbrannlayt" wrote: > I have this function in 2007 version, but need to make it work in 2003. What > function would be compatible? > > =COUNTIFS('Cancel Detail First 60 Days'!$B$1:$B$163,"GGL",'Cancel Detail > First 60 Days'!$I$1:$I$163,"UW") > > |