Multiple criteria outcome #VALUE

**Christopherdj** · 10-30-2011, 08:52 PM

I have the attached file, In the 'Summary' sheet, I have references to Master Sheet, criteria in row 21 is giving me #VALUE as an outcome when it should be adding Column E in the 'Master' sheet.

What am I doing wrong? The other criteria works in the Summary sheet.

**foxguy** · 10-30-2011, 09:23 PM

If no one else answers you, I will take a look.
You'll have to save it as .xls since I only have Excel 2003 on this computer.

**Christopherdj** · 10-30-2011, 10:31 PM

1997-2003 version uploaded.

thanks

**foxguy** · 10-30-2011, 11:14 PM

Your formula doesn't like the contents of E3, E6, E30 and more. It worked fine up until it tried to combine the contents of E2:E1000 in with the rest of the calculations.

I copied the contents of D3 into those 3 cells and got rid of the 1st 3 errors in the results.
I believe that D3 is empty, E3, E6, E30 and more have a " " in them.
I used End+DownArrow in column E and it went right through E30, but End+DownArrow in column D stopped on D29.

So delete the contents of all cells in Column E that have a " ". If that doesn't work let me know and I'll try again. I don't use array formulas and I'm very rusty with how they work and I have never put so many together, but I'll try.

**Christopherdj** · 10-30-2011, 11:42 PM

Well I replaced all spaces " " in column E and the formula worked, thank you very much for your help. There had to be a reason for it not to work and the spaces within cells was the issue. I will mark problem solved, thanks for your help.