SUM with Nested IF and using OR 1

[planopeets]

I have the below statement to sum the number of FTE's for a Job Function. I want to add an OR type condition to the below statement, so it is adding 2 or more Job Functions, for example Job_Function = "Business Consultant" or Job_Function = "Programmer".

Thoughts on how to do this?

=SUM(IF(Job_Function=&quot;Business Consultant&quot;,IF(Start_Date<=$A21,IF(End_Date>=$A21,(1*Allocated)))))

 

[KenWright]

=SUM(IF(Job_Function={&quot;Business Consultant&quot;,&quot;Programmer&quot;},IF(Start_Date<=$A21,IF(End_Date>=$A21,(1*Allocated)))))

Array entered - CTRL+ENTER+SHIFT

Regards
Ken...............

 

[KenWright]

And the other option of course, is as follows:-

=SUMPRODUCT((Job_Function={&quot;Business Consultant&quot;,&quot;def&quot;})*(Start_Date<=$A21)*(End_Date>=$A21)*(1*Allocated))

Regards
Ken.............