Test_Database_2021
New Member
- Joined
- Apr 6, 2021
- Messages
- 9
- Office Version
- 365
- 2016
- 2010
- Platform
- Windows
Hi!
So I have a table with multiple COUNTIFs formulas. The total Excel file is 4MB.
However, none of the COUNTIFs formulas reference other formulas, just text, so it should not be too complicated.
Even so, many of the formulas are "undercounting" (not counting all the cells).
E.g. this formula: =COUNTIFS(Patients!$R:$R,"<>",Patients!$R:$R,"<>"&Metadata!$O$9,Patients!$Z:$Z,B15)
Things I have already tried:
- making sure the source cell range Z really does contain the exact same text as B15
- trying to replace the range Z with the concrete cells (Z1:Z4198) - but then it gives me #VALUE error
- copy/pasting absolutely everything into a new Excel file
- starting a new Excel file that is smaller and contains just a few formulas
--> What could be wrong?
So I have a table with multiple COUNTIFs formulas. The total Excel file is 4MB.
However, none of the COUNTIFs formulas reference other formulas, just text, so it should not be too complicated.
Even so, many of the formulas are "undercounting" (not counting all the cells).
E.g. this formula: =COUNTIFS(Patients!$R:$R,"<>",Patients!$R:$R,"<>"&Metadata!$O$9,Patients!$Z:$Z,B15)
Things I have already tried:
- making sure the source cell range Z really does contain the exact same text as B15
- trying to replace the range Z with the concrete cells (Z1:Z4198) - but then it gives me #VALUE error
- copy/pasting absolutely everything into a new Excel file
- starting a new Excel file that is smaller and contains just a few formulas
--> What could be wrong?