COUNTIFS - Is this correct?

[monkeyharris]

Hi all,

Hope you can help. Think i'm doing this correct but isn't working i think because of dates.

My table is A2 to P5000. I was using =COUNTIFS(E:E,T3,P:P,1)

Column E:E is dates during the year, Column P:P is number of days which is a calculation between order recieve and order due. T3 is a lookup to show the month I need to get a result for (1 to 12).

Basically if T3 is 9, i need the formlar to look i E:E for dates in September and count how many say 1 in column P:P

 

[jasonb75]

Hi Jason, I tried the Sumproduct this morning but it gives a 0 result. The COUNTIFS worked great.

It works fine for me, maybe you had parenthesis in the wrong places.

To do a greater than count with countifs you need to use ">5", not >5

 

[monkeyharris]

No, the results show how many orders per month have 1, 2, 3 days notice. I still need that but i also want to sum the remaining orders over 5 day.

 

[monkeyharris]

The ">5" worked fine.