Formula Help

Minni

I am for some reason having an issue getting function to calculate correctly. I need to pull the count for just active projects in one column but it is calculating all of them. There should only be 143. Can anyone help with this?

=SUMIF([Project Phase]:[Project Phase], "Active")

=COUNTIF([Project Phase]:[Project Phase], "Active")

=COUNTIFS([Project Phase]:[Project Phase], "Active")

Paul Newcome

Try a COUNTIFS instead.

Minni

I have tried it and it is not giving m the correct number. I have tried SUM, SUMIF, SUMIFS, COUNT, COUNTIF, and COUNTIFS and it is just not working

Hollie Green

what count is it giving you when you use the =COUNTIF([Project Phase]:[Project Phase], "Active")

Paul Newcome

Have you double checked that there are no filters applied to the source data?