Microsoft Office Forums - View Single Post - CountiF or CountiFs two columns conditions

Thread: CountiF or CountiFs two columns conditions

View Single Post

Old

04-30-2014, 04:14 PM

momentman

momentman is offline

momentman uses Windows 7 64bit

Windows 7 64bit momentman uses Office 2010 32bit

momentman uses Office 2010 32bit

Office 2010 32bit

Novice

Join Date: Apr 2014

Location: Nigeria

Posts: 5

momentman is on a distinguished road

Default

Maybe you can attempt something like this:

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

Reply With Quote