matching for multiple columns

[blott5fm]

I have the formula =1-SUMIFS(C:C,A:A,F1)/H1. I need a formula that will not only check for a match in cell F1 but also G1, H1 and I1. I tried =1-SUMIFS(C:C,A:A,F1:I1)/H1 but that doesn't work. Any help is greatly appreciated.

 

[DRSteele]

SUMIFS cannot handle arrays in the criteria argument. SUMPRODUCT is a solution. {Note that selecting the entire Columns will slow down recalc.)

Excel 2012
	A	B	C	D	E	F	G	H	I	J
1	dog		5			dog	beef	venison	veal	59
2	venison		10
3	chicken		17
4	beef		19
5	fish		22
6	veal		25
Sheet41

Cell Formulas
Range	Formula
J1	=SUMPRODUCT((A:A=F1)+(A:A=G1)+(A:A=H1)+(A:A=I1),C:C)

 

[DRSteele]

Actually, this is even easier, cell J1 =SUMPRODUCT((A:A=F1:I1)*C:C)