#Value error from a Countifs formula

**Befuddled** · 04-02-2010, 09:05 PM

Hopefully someone can help me with this.
I am getting a #Value error in a countifs formula for some reason. I copied and pasted the last part of the formula in G4 into the last part of the formula in N4, in the Excel file that I have attached, but it doesnt want to work in N4. I tried changing the format of the cell, and a few other things, but nothing gets rid of the #Value error except removing the ",$J$7:$J$304,$D$4" that I added to the formula. All of this is in the 2009 sheet.

**mdbct** · 04-02-2010, 09:37 PM

Your range for the other portions of the Counifs are from row 7 to row 305, while the "Die Issues" part is from row 7 to row 304.

**Befuddled** · 04-02-2010, 09:57 PM

Thanks,
I knew it had to be something simple that I was overlooking. I forgot that I had added a row earlier.

**Patlox** · 01-04-2011, 02:03 PM

Hello,

Please I am getting a #VALUE! error when i refresh my Data. I am creating a report whose source data is an Oracle database.

I used the COUNTIFs formula to create my report which actually works fine. But when I refresh the source data, it gives me the #VALUE! error. I realized that the refresh action changes one of the criteria range.

E.g

The original formula is

=COUNTIFS('Query from EXPRESS'!$H$2:$H$2000,E23,'Query from EXPRESS'!$E$2:$E$2000,$A$24,'Query from EXPRESS'!$I$2:$I$2000,$H$21)

But after refreshing, I get

=COUNTIFS('Query from EXPRESS'!$H$2:$H$2000,E23,'Query from EXPRESS'!$E$2:$E$1472,$A$24,'Query from EXPRESS'!$I$2:$I$2000,$H$21).