Sum, countifs, and

[RJB78]

Hello. I am trying to get a count of the cells that contain certain texts in one column (K) AND have a cell value greater than 2.5% (.025) in a different column (O)

This is the formula I am using now:

=SUM(AND(COUNTIFS(K:K,{"GROWTH1","GROWTH2","GROWTH3","GROWTH4"}),O:O>0.025))

I am getting a return of 0

 

[63falcondude]

Try

=SUM(COUNTIFS(K:K,{"GROWTH1","GROWTH2","GROWTH3","GROWTH4"},O:O,">0.025"))

 

[Joyner]

Without seeing further examples of your data, maybe:

=SUM(COUNTIFS(K:K,"GROWTH"&{1,2,3,4},O:O,">.025")) Although I would replace the K:K and O:O with just the actual range used.

If there is only GROWTH1 through 4 in you data you could use:

=COUNTIFS(K:K,"GROWTH*",O:O,">.025")

 

[RJB78]

@falcon Thank you. That worked.

 

[63falcondude]

@falcon Thank you. That worked.

Glad to help.