Can I overlay Filter( ) formula over SUMIFS formula?

[jayjay123]

Hi Excel Experts!
Hoping to find some help with the below. I have made a dummy dataset. But basically I am trying to find an automated way to sumifs the dataset, then remove rows with all 3 blanks. Is the Filter( ) formula appropriate? or would there be an alternative formula to make this more efficient?

Thanks heaps!

 

[awoohaw]

how about:

mr excel questions 12.xlsm
	A	B	C	D	E	F	G	H
1
2	Choice	Fruit	Type	Sugar Level	Number	Multiplier	Total
3	Yes	Orange	Citrus	Over 80	5	1.5	7.5
4	No	Apple	Regular	Over 90	10	1.3	13
5	Yes	Mango	Tropical	Under 10	0	1.8	0
6	Yes	Lemon	Citrus	Under 10	4	0	0
7	Yes	Raspberry	Berry	Under 10	3	1.2	3.6
8	No	Blueberry	Berry	Over 5	0	0	0
9	No	Strawberry	Berry	Over 5	8	0.9	7.2
10	No	Strawberry	Berry	Over 7	10	0.5	5
11	Yes	Orange	Citrus	Over 80	5	1.5	7.5
12
13	Choice	Fruit	Type	Sugar Level	Number	Multiplier	Total
14	Yes	Orange	Citrus	Over 80	5	1.5	7.5
15	No	Apple	Regular	Over 90	10	1.3	13
16	Yes	Mango	Tropical	Under 10	0	1.8	0
17	Yes	Lemon	Citrus	Under 10	4	0	0
18	Yes	Raspberry	Berry	Under 10	3	1.2	3.6
19	No	Strawberry	Berry	Over 5	8	0.9	7.2
20	No	Strawberry	Berry	Over 7	10	0.5	5
21	Yes	Orange	Citrus	Over 80	5	1.5	7.5
22
Sheet30

Cell Formulas
Range	Formula
A14:G21	A14	=FILTER(A3:G11,(E3:E11>0)+(F3:F11>0)+(G3:G11>0),"")
Dynamic array formulas.

 

[fjns]

Hi, the formula for A29 cell:
=UNIQUE(FILTER(A3:G11,(E3:E11>0)+(F3:F11>0)+(G3:G11>0),""),0)

 

[awoohaw]

Hi, the formula for A29 cell:
=UNIQUE(FILTER(A3:G11,(E3:E11>0)+(F3:F11>0)+(G3:G11>0),""),0)

what does the unique do in this situation?