If statement within sum if string of conditions

[khersh]

I am trying to have excel look at numerous conditions an return a specific number. I have been able to use SUM IFS but have hit a snag. The condition I am trying to apply is whether the number in column on given Sheet (SHEET1'A1:A100) matches the number in my reference column on a separate sheet (Sheet2'B1:B100); assuming it does, I want to return the number from my sum range...what I am struggling with is if that if (SHEET1'A1:A100) is blank, and only if its blank, i want to then look to (Sheet1'C1:C100) and reference that in turn to (Sheet2'B1:B100). Thanks for any help.

 

[Aladin Akyurek]

Would you elaborate a bit more if what follows is not what you want:

SHEET1

B1, copied down:

=INDEX(SumRange,MATCH(IF($A1="",$C1,$A1),SHEET2!$B$1:$B$10,0))

where you need to fill in the sum range?

 

[khersh]

Thanks Aladin,

I have tried to further clarify my question in this post: http://www.mrexcel.com/forum/excel-questions/728389-sumifs-isblank.html. Thanks for any further thoughts you have.

Best,
KHersh

 

[Aladin Akyurek]

Thanks Aladin,

I have tried to further clarify my question in this post: http://www.mrexcel.com/forum/excel-questions/728389-sumifs-isblank.html. Thanks for any further thoughts you have.

Best,
KHersh

You could have continued to do so here...