Excel Sumifs with #Value errors if blank cells in range

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
LVL 1
MarkVrenkenAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
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
 
MarkVrenkenAuthor Commented:
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
 
MarkVrenkenAuthor Commented:
is this a fair way to grade? i'm fairly new to the point system.

greetings,

Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.