changing cell value makes the formula plain text

[spandon]

I have a working formula:

=COUNTIFS(E3:E74,"In Progress",F4:F74,A97)+COUNTIFS(E4:E74,"Not
Done",F4:F74,A97)

BUT when I change something like E3, to E4, the formula appears simply as
plain text.

Any ideas?
Stergios

 

[Jacob Skaria]

The row references should be same for all conditions. 4 to 74 ... as
below...You dont need to repeat countifs() instead you can try the below
version.

=SUM(COUNTIFS(E4:E74,{"In Progress","Not Done"},F4:F74,A97))