range count

[febausa]

I search some formula collects by categories

I have attached example

Thank you for your help.

 

[Hui]

It is very hard to access the colors of CF cells
It is easier to replicate the logic of the CF in your Count or Sum formula

B11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>2.2))

C11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1.8)*($A$2:$BG$2<=2.2))

D11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1.4)*($A$2:$BG$2<=1.8))

E11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1)*($A$2:$BG$2<=1.4))

F11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2<=1))

Copy all down

By the way F10 should say Pink, Not Blue

See attached file:

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[febausa]

It is very hard to access the colors of CF cells
It is easier to replicate the logic of the CF in your Count or Sum formula

B11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>2.2))

C11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1.8)*($A$2:$BG$2<=2.2))

D11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1.4)*($A$2:$BG$2<=1.8))

E11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2>1)*($A$2:$BG$2<=1.4))

F11: =SUMPRODUCT(--(INT((COLUMN($A$1:$BG$1)-0.1)/12)+1=ROWS($A$11:$A11))*($A$2:$BG$2<=1))

Copy all down

By the way F10 should say Pink, Not Blue

See attached file:

Hi Hui:

Thank you, your formula is good.

febausa