Show nothing if there is no data in one of the criteria

[K0st4din]

Hello, everyone,
I ask for your help for the shown formula, which works and calculates everything correctly, but I can not handle this if in any of the cells in column C is empty (ie there is no data) the cell in which this formula is located show nothing (be empty). Because obviously I'm wrong and I don't know how to say, to do the same, but if there is no information it should be empty, and at the moment it gives me a total sum of a number (sum).
I get the result I get from several columns with data and dates!
Thank you in advance for your cooperation!

=SUMIFS(Sheet1!$P$1:$P$300000;Sheet1!$D$1:$D$300000;">="&$F$2;Sheet1!$D$1:$D$300000;"<="&$G$2;Sheet1!$B$1:$B$300000;Sheet2!$A10;Sheet1!$J$1:$J$300000;"*"&Sheet2!$C10&"*")

 

[mart37]

With one SUMIFS you create AND-relations. If one criterium is false then all are false = empty
Maybe you can solve this when you seperate your SUMIFS in multiple SUMIF.

 

[K0st4din]

Ok, but then won't the formula become quite long. Could you write according to my formula, your idea. Thank you very much.

 

[mart37]

=SUMIFS(Sheet1!$P$1:$P$300000;Sheet1!$D$1:$D$300000;">="&$F$2;Sheet1!$D$1:$D$300000;"<="&$G$2;Sheet1!$B$1:$B$300000;Sheet2!$A10;Sheet1!$J$1:$J$300000;"*"&Sheet2!$C10&"*")+SUMIFS(Sheet1!$P$1:$P$300000;Sheet1!$D$1:$D$300000;">="&$F$2;Sheet1!$D$1:$D$300000;"<="&$G$2;Sheet1!$B$1:$B$300000;Sheet2!$A10;Sheet1!$J$1:$J$300000;"")

 

[Fluff]

Maybe

=IF(C10="","",SUMIFS(Sheet1!$P$1:$P$300000,Sheet1!$D$1:$D$300000,">="&$F$2,Sheet1!$D$1:$D$300000,"<="&$G$2,Sheet1!$B$1:$B$300000,Sheet2!$A10,Sheet1!$J$1:$J$300000,"*"&Sheet2!$C10&"*"))

 

[K0st4din]

Many thanks to both of you!
I hadn't thought of this IF in the beginning.
Maybe because my formula itself has become quite long!
But now everything is as it should be!
You are just wonderful!
I wish you good health!

 

[Fluff]

Glad we could help & thanks for the feedback.