Thread: Need help building COUNTIFS solution
View Single Post
 
Old 02-26-2015, 01:41 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Quote:
Originally Posted by 676nova View Post
The initial suggestion using SUMPRODUCT did not give the correct answer
You mean Peco's formula? I tried it and it worked fine. The answer for the data given is 3.
Reply With Quote