CountiF or CountiFs two columns conditions

momentman · #1 04-30-2014, 04:14 PM

Maybe you can attempt something like this:

=SUMPRODUCT((C9:C90="Blast Email")*(1/COUNTIF(B9:B90,B9:B90)))

Oceans · #2 04-30-2014, 04:30 PM

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)))

Oceans · #3 04-30-2014, 04:49 PM

Have a look at the second sheet, numbers are off.

Bulk Update should not be 141.666

Quote:

Originally Posted by momentman

Maybe you can attempt something like this:

=SUMPRODUCT((C9:C90="Blast Email")*(1/COUNTIF(B9:B90,B9:B90)))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIFS Help Needed	OTPM	Excel	2	04-09-2014 08:32 AM
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
Compound Countifs Query not working	Lonercom	Excel	5	06-28-2013 10:27 AM
Countifs and Sumproduct	Algo	Excel	6	11-13-2012 07:44 AM
countifs?	sonyaturpin	Excel	1	05-23-2012 08:29 AM