changing cell value makes the formula plain text
 

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

changing cell value makes the formula plain text
 

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))

--
Jacob


"spandon" wrote:

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