Count 2 col's data (Sec's 0 - 6 & "Reviewed" o

[scoobyblue]

Column C cells have either 0, 1, 2, 3, 4, 5 or 6 (Sectors) entered and Column K has text entered ("Reviewed") but some cells will be blank.

I want to be able to count the number of occurrences where text is entered in col' K for 0, 1, 2, 3 etc. Basically, how many of the different Sectors have been reviewed.

So by having a different Cell that can be changed to any number from 0 to 6, another cell would always show the relevant number of matches where they have been Reviewed (this text is input into the ActiveCell in Col' K when a macro is run).

Hope it makes sense, thanks for your help.

Stewart

 

[MycroftII]

Try

{=SUM(($C$1:$C$999=Number)*ISTEXT($K$1:$E$999))}

Note that this is an array formula, ie. leave out the curly brackets when entering it - end enter it with CTRL + SHIFT + Enter.

Number refers to the number you want to count. Ie. you need 7 cells contains 0..6 and this formula, each referring to one of these cells.

 

[Aladin Akyurek]

Re: Count 2 col's data (Sec's 0 - 6 & "Reviewed&quo

=SUMPRODUCT(--(SectorRange=Sector),--(StatusRange="Reviewed"))

which just needs enter. Sector is a cell that houses a sector number.