for a number of years, I’d been using a formula:
=COUNTIF(OFFSET(RFP,$B$2+1,C$5,$B$3,1)+OFFSET(RFP,$B$2+1,$B6,$B$3,1),$B$4)
The idea was to go through a table and check where the sum of two columns met the criterion in $B$4. I came back to the spreadsheet after a couple of week, and the counts no longer appear – they show up as ERR504. (and yes, the counts were accurate – manually checked).
I have found that “=COUNTIF(OFFSET(RFP,$B$2+1,C$5,$B$3,1),$B$4)” gives a right answer (no errors, but the original version doesn’t.
Can anyone explain what changed?
Note: the original formula works in Excel and in Google Docs