|
04-30-2014, 04:30 PM
|
|
Novice
|
|
Join Date: Mar 2011
Posts: 11
|
|
I found a discrepancy / glitch. the excel sheet i have sent was a sample with a small size data. The actual excel sheet has 1624 rows, so now the formula yields wrong count.
Quote:
Originally Posted by momentman
Maybe you can attempt something like this:
=SUMPRODUCT((C9:C90="Blast Email")*(1/COUNTIF(B9:B90,B9:B90)))
|
|