Convert COUNTIFS function from 2007 to something in 2003 version

  • Thread starter Thread starter cbrannlayt
  • Start date Start date
C

cbrannlayt

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")
 
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.
 
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.
 
Back
Top