Formula (Count Neg Numbers)

[ironsides]

Starts Cell AB19 - AM19

Col AB has numbers from 1 to 999
Col AM has pos or neg numbers

I want to search col AB for numbers from 10 to 19.99 and,

in Cell AE13, show the total of positive numbers found in Col AM
that corresponds to the conditions that was found in the Col AB

 

[Aladin Akyurek]

In AE13 enter:

=COUNTIFS(AB:AB,">=10",AB:AB,"<=19.99",AM:AM,">0")

For neg count, change ">0" to "<0".

 

[ironsides]

Aladin...works like a charm thank you Matt

 

[Aladin Akyurek]

Aladin...works like a charm thank you Matt

You are welcome.