function too short message.

[marco10]

=COUNTIFS(C:C,"Project Director/Manager-Civil",D:D,"temp",(or(E:E=may-20,E:E=mar-20,E:E=jan-20,"ans")))

i am trying to count the number of "Project Director/Manager-Civil" in column C which has text "Temp" in D and finally on E it could be any from "Jan-20 to dec-20",

this would work if i remove the part after "or" but i need that date part too.

can anyone please tell me what is wrong with this formula.

i keep on getting the message
( you've entered too few arguments for this function.)
Grateful for your Help,
kind regards.

 

[jasonb75]

The correct way to do an OR in countifs is

=SUM(COUNTIFS(C:C,"Project Director/Manager-Civil",D:D,"temp",E:E,{multiple criteria}))

I'm lost as to what you want to do with the dates, are you looking for:-
-any dates between a specific start and end date?
-specific month end dates?
-any date in a number of specific non-consecutive months ?
-Something else?

 

[marco10]

Thank you. Your Support is appreciated Jason.
Actually i was trying to insert a criteria where it allows entry of people joining in different dates but then realized there is no point in doing that.
but yup thank you very much for your sharing of knowledge as i can use it in future for other reasons.