Help with Formula

asha.D

Hello- I am needing assistance with creating a formula to count the active FTEs that are on an active project. Not sure what to select first and second to pull the count per FTE.

Thank you

Jgorsich

This seems like a sumif scenario if what you are trying to do is get the total FFEs on active projects:

=sumifs(ffecount:ffecount,active:active,true)

If what you are trying to do is get the value in FFEcount, it seems like a countm inside an if would do ya:

=if(active@row=true,countm(FFEresources@row),0)

DKazatsky2

Hi @asha.D

Try this. =IF(Active@row = 1, COUNTM([FTE Resources]@row))

Hope this helps,

Dave

asha.D

Thank you both for providing me some formulas, but neither are pulling the correct count. Still stuck ;(