?
Solved

Excel Sumifs with #Value errors if blank cells in range

Posted on 2012-08-28
3
Medium Priority
?
1,459 Views
Last Modified: 2012-08-28
Hi,

I'm having some trouble with the sumif function in excel. I have blank cells in my range so that i can select a long range. like

243      55      0      22 Blank cell blank cell, etcetera

But when i have this range it returns a #Value error.
Hope someone knows how to fix this!

Kind regards,

Mark
0
Comment
Question by:MarkVrenken
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
Rob Henson earned 400 total points
ID: 38340508
Are the cells truly blank?

Could be a formula resulting in a space (" ") or blank ("") that is throwing it out.

Are the numbers truly numerical or are they text?

A sample file would be good.

Thanks
Rob H
0
 
LVL 1

Author Comment

by:MarkVrenken
ID: 38340523
I'm sorry i made a mistake. It's not the blank values that were the problem but i forgot that the criteria range and sum range must be equal. That's why i got the #value error.
Thanks for your attempt to help me:)
0
 
LVL 1

Author Comment

by:MarkVrenken
ID: 38340526
is this a fair way to grade? i'm fairly new to the point system.

greetings,

Mark
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question