ISBLANK with SUMIFS?

Hi all,

I have a problem with an "isblank" formula. I have a sumifs formula, that works just fine. Issue is, that it returns "0" for empty cells. I want it to return an "N/A", though. I wrote the following formula*:

Formula:

Please Login or Register  to view this content.

* Sheet1 is in a different workbook, I just deleted the file name before it.

Is the formula "wrong"? If I just go to the respective cell and write:

Formula:

Please Login or Register  to view this content.

it returns "N/A".

Thanks a lot in advance for your support!

Not having tested it yet, but if the cell actually contains a "0", I want it to return "0".

Both .

If I have a cell, that is empty, i.e. "", I want the formula to return "N/A".
If the cell actually contains "0", I want the formula to return "0".

I have created a really simple example sheet, but it shows the error quite well.
Column E includes just the sumifs, Column F the embedded sumifs in isblank and if, and Column G has just the check if a cell is empty.
The result in Column F should look exactly like Column D.

The purpose of the formula is to collect the data for a much bigger sheet. I am aware, that in my example sheet there are easier solutions .

I suppose that works in this example sheet, but since I would have to use a means to identify the cell in the first place, I would need a sumifs formula (I guess) to identify the respective cell to check if that cell is empty. I suppose I can just go with =if(sumifs(...)="";"";sumifs(...)), right? Will try this.