Thread: CountiF or CountiFs two columns conditions
View Single Post
 
Old 04-30-2014, 04:49 PM
Oceans Oceans is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Mar 2011
Posts: 11
Oceans is on a distinguished road
Default
Have a look at the second sheet, numbers are off.

Bulk Update should not be 141.666


Quote:
Originally Posted by momentman View Post
Maybe you can attempt something like this:

=SUMPRODUCT((C9:C90="Blast Email")*(1/COUNTIF(B9:B90,B9:B90)))
Attached Files
File Type: xlsx Analysis Summary Report_Excel.xlsx (36.1 KB, 12 views)
Reply With Quote