changing cell value makes the formula plain text

S

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
 
J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically populate value of cell dependent on adajecent cell 3
Formula 6
Fill down formula (but changing cell value by two) 2
Searching the formula (not the value) for a text string 1
Referring to a cell by using another cell for the row number 6
SUMIF, wrong result, strange behaviour 5
Tricky Formula 2
Employing constant arrays to limit nested IF statements. 2

Top