adding cells based on criteria across several columns

[jbrown021286]

TECH HOURS WORKSHEET 6.0 test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD
1	1-Jan	22-Apr
2	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced	Name	Number	Days Worked	Hours Produced
3	Jan				Feb				Mar				Apr				May				Jun				Jul				Aug				Sep				Oct				Nov				Dec				Current				Total hours		Total Days Worked
4	Jeff	101502	15	207.2	Jeff	101502	22	264.1	Jeff	101502	23	311.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Jeff	101502	16	227.35	Jeff		Jeff
5	Justin	101549	23	188.5	Justin	101549	20	170.9	Justin	101549	24	240.9	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Justin	101549	16	189.9	Justin		Justin
6	Ramy	103642	20	182.8	Ramy	103642	17	152.4	Ramy	103642	25	365.3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Ramy	103642	16	208.65	Ramy		Ramy
7	Tuzzo	107132	19	-547	Tuzzo	107132	22	136.5	Tuzzo	107132	17	100.65	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Tuzzo	107132	6	43	Tuzzo		Tuzzo
8	Brandun	107471	24	198.1	Brandun	107471	11	87.1	Brandun	107471	9	76.65	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Brandun	107471	16	125.25	Brandun		Brandun
9	Carl	107801	19	143.1	Carl	107801	18	153.5	Carl	107801	19	240.6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Carl	107801	18	128.25	Carl		Carl
10	Rod Jones	108228	15	36.7	Rod Jones	108228	16	51.8	Rod Jones	108228	17	66.6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Rod Jones	108228	13	34.6	Rod Jones		Rod Jones
11	Que	108243	24	91.4	Que	108243	23	108.05	Que	108243	22	135.4	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Que	108243	16	102.6	Que		Que
12	James	108410	23	154.35	James	108410	23	166.25	James	108410	24	200.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	James	108410	17	102.7	James		James
13	Owens	108634	21	155.4	Owens	108634	20	175.8	Owens	108634	22	208.5	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Owens	108634	13	111	Owens		Owens
14	Hawk	109543	23	119.8	Hawk	109543	24	201.1	Hawk	109543	1	2.6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Brandun Mcghee	1021045	15	53.5	Brandun Mcghee		Brandun Mcghee
15	Josh	109572	20	163.8	Josh	109572	21	200.4	Josh	109572	23	227.3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Josh	109572	12	96.55	Josh		Josh
16	David	109783	19	83.9	David	109783	19	122.8	David	109783	19	152.75	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	David	109783	13	65.5	David		David
Custom Data Gathered

Cell Formulas
Range	Formula
A1:B1	A1	='Custom Hours'!D6
A4:B16	A4	=Jan!A4
C4:C16	C4	=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C4:AG4,">.9")
D4:D16	D4	=SUMIFS(Jan!A4:AG4,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E4:F16	E4	=Feb!A4
G4:G16	G4	=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C4:AG4,">.9")
H4:H16	H4	=SUMIFS(Feb!A4:AG4,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I4:J16	I4	=Mar!A4
K4:K16	K4	=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C4:AG4,">.9")
L4:L16	L4	=SUMIFS(Mar!A4:AG4,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M4:N16	M4	=Apr!A4
O4:O16	O4	=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C4:AG4,">.9")
P4:P16	P4	=SUMIFS(Apr!A4:AG4,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q4:R16	Q4	=May!A4
S4:S16	S4	=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C4:AG4,">.9")
T4:T16	T4	=SUMIFS(May!A4:AG4,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U4:V16	U4	=Jun!A4
W4:W16	W4	=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C4:AG4,">.9")
X4:X16	X4	=SUMIFS(Jun!A4:AG4,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y4:Z16	Y4	=Jul!A4
AA4:AA16	AA4	=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C4:AG4,">.9")
AB4:AB16	AB4	=SUMIFS(Jul!A4:AG4,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC4:AD16	AC4	=Aug!A4
AE4:AE16	AE4	=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C4:AG4,">.9")
AF4:AF16	AF4	=SUMIFS(Aug!A4:AG4,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG4:AH16	AG4	=Sep!A4
AI4:AI16	AI4	=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C4:AG4,">.9")
AJ4:AJ16	AJ4	=SUMIFS(Sep!A4:AG4,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK4:AL16	AK4	=Oct!A4
AM4:AM16	AM4	=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C4:AG4,">.9")
AN4:AN16	AN4	=SUMIFS(Oct!A4:AG4,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO4:AP16	AO4	=Nov!A4
AQ4:AQ16	AQ4	=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C4:AG4,">.9")
AR4:AR16	AR4	=SUMIFS(Nov!A4:AG4,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS4:AT16	AS4	=Dec!A4
AU4:AU16	AU4	=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C4:AG4,">.9")
AV4:AV16	AV4	=SUMIFS(Dec!A4:AG4,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW4:AW16,BA4:BA16,BC4:BC16	AW4	='Aggregated Data'!$A4
AX4:AX16	AX4	='Aggregated Data'!B4
AY4:AY16	AY4	=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C4:AG4,">.9")
AZ4:AZ16	AZ4	=SUMIFS('Aggregated Data'!C4:AG4,'Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1)

i was originally going to us a sumif function for this but it exceeds the argument capacity of the function. what i need to do is have a formula in column BB that adds any cells in the columns labeled "hours produced" in row 2 where the column labeled "name" matches column BA. for example since BA4 is "Jeff" then D4, H4, L4, AZ4 would all need to be added. the months that are not filled in the sheet yet may have the names in a different order so the formula can not be confined to 1 row of data. any help would be appreciated.

 

[Cubist]

Try:

=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))

 

[jbrown021286]

Try:

=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))[/C
[/QUOTE]

Try:

=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))

TECH HOURS WORKSHEET 6.0 test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE
22	Jerusha	1021028	20	55.4	Jerusha	1021028	20	48.9	Jerusha	1021028	4	9.6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Miguel	103699	14	182.45	Miguel	296.35	Miguel
23	Gerrardo	1021029	22	71.5	Gerrardo	1021029	20	81.2	Gerrardo	1021029	21	126.7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Gerrardo	1021029	14	103.85	Gerrardo	383.25	Gerrardo
24	Tre	1021032	15	55.2	Tre	1021032	22	80.25	Tre	1021032	21	102.95	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Tre	1021032	16	68.6	Tre	307	Tre
25	Harry	1021037	7	16.7	Harry	1021037	19	59.3	Harry	1021037	21	66	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Harry	1021037	15	59.2	Harry	201.2	Harry
26	Contrer	1021038	3	7.3	Contrer	1021038	4	6.6	Contrer	1021038	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Trevin	1021039	16	80.95	Trevin	94.85	Trevin
27	Trevin	1021039	0	1.4	Trevin	1021039	21	72.35	Trevin	1021039	22	98.75	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Venro	1021040	12	49	Venro	221.5	Venro
28	Venro	1021040	1	9.4	Venro	1021040	18	138.1	Venro	1021040	21	134.1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	281.6	Blank
29	Sheldon	1021012	19	98.3	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	98.3	Blank
30	Myles	109527	10	31	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	31	Blank
31	JJ	108271	0	0.2	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	0.2	Blank
32	house	99	6	14.5	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	14.5	Blank
33	Ryan	100335	17	99.4	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	99.4	Blank
34	Blank	0	0	0	House	99	7	28.55	house	99	0	-9.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	house	99	2	3.8	house	23.1	house
Custom Data Gathered

Cell Formulas
Range	Formula
A22:B34	A22	=Jan!A22
C22:C34	C22	=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C22:AG22,">.9")
D22:D34	D22	=SUMIFS(Jan!A22:AG22,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E22:F34	E22	=Feb!A22
G22:G34	G22	=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C22:AG22,">.9")
H22:H34	H22	=SUMIFS(Feb!A22:AG22,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I22:J34	I22	=Mar!A22
K22:K34	K22	=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C22:AG22,">.9")
L22:L34	L22	=SUMIFS(Mar!A22:AG22,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M22:N34	M22	=Apr!A22
O22:O34	O22	=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C22:AG22,">.9")
P22:P34	P22	=SUMIFS(Apr!A22:AG22,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q22:R34	Q22	=May!A22
S22:S34	S22	=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C22:AG22,">.9")
T22:T34	T22	=SUMIFS(May!A22:AG22,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U22:V34	U22	=Jun!A22
W22:W34	W22	=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C22:AG22,">.9")
X22:X34	X22	=SUMIFS(Jun!A22:AG22,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y22:Z34	Y22	=Jul!A22
AA22:AA34	AA22	=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C22:AG22,">.9")
AB22:AB34	AB22	=SUMIFS(Jul!A22:AG22,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC22:AD34	AC22	=Aug!A22
AE22:AE34	AE22	=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C22:AG22,">.9")
AF22:AF34	AF22	=SUMIFS(Aug!A22:AG22,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG22:AH34	AG22	=Sep!A22
AI22:AI34	AI22	=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C22:AG22,">.9")
AJ22:AJ34	AJ22	=SUMIFS(Sep!A22:AG22,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK22:AL34	AK22	=Oct!A22
AM22:AM34	AM22	=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C22:AG22,">.9")
AN22:AN34	AN22	=SUMIFS(Oct!A22:AG22,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO22:AP34	AO22	=Nov!A22
AQ22:AQ34	AQ22	=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C22:AG22,">.9")
AR22:AR34	AR22	=SUMIFS(Nov!A22:AG22,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS22:AT34	AS22	=Dec!A22
AU22:AU34	AU22	=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C22:AG22,">.9")
AV22:AV34	AV22	=SUMIFS(Dec!A22:AG22,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW22:AW34,BA22:BA34,BC22:BC34	AW22	='Aggregated Data'!$A22
AX22:AX34	AX22	='Aggregated Data'!B22
AY22:AY34	AY22	=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C22:AG22,">.9")
AZ22:AZ34	AZ22	=SUMIFS('Aggregated Data'!C22:AG22,'Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1)

this formula wil not work for this application because the cells that need to be added "indicated by the name column" are not alwaise in the same row and the formula

 

[Cubist]

In the OP, in column BA, you referenced column A so misleading. Try

=BYROW(BA3:BA15,LAMBDA(br,SUM(FILTER(FILTER(A3:AZ15,A2:AZ2="Hours Produced"),A3:A15=br))))

 

[jbrown021286]

In the OP, in column BA, you referenced column A so misleading. Try

=BYROW(BA3:BA15,LAMBDA(br,SUM(FILTER(FILTER(A3:AZ15,A2:AZ2="Hours Produced"),A3:A15=br))))

TECH HOURS WORKSHEET 6.0 test.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD
21	Frederick	1021027	19	105.6	Frederick	1021027	20	168.5	Frederick	1021027	10	68.2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Kedrin	1021054	4	25.2	Kedrin	#CALC!	Kedrin
22	Jerusha	1021028	20	55.4	Jerusha	1021028	20	48.9	Jerusha	1021028	4	9.6	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Miguel	103699	14	182.45	Miguel	#CALC!	Miguel
23	Gerrardo	1021029	22	71.5	Gerrardo	1021029	20	81.2	Gerrardo	1021029	21	126.7	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Gerrardo	1021029	14	103.85	Gerrardo	383.25	Gerrardo
24	Tre	1021032	15	55.2	Tre	1021032	22	80.25	Tre	1021032	21	102.95	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Tre	1021032	16	68.6	Tre	307	Tre
25	Harry	1021037	7	16.7	Harry	1021037	19	59.3	Harry	1021037	21	66	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Harry	1021037	15	59.2	Harry	201.2	Harry
26	Contrer	1021038	3	7.3	Contrer	1021038	4	6.6	Contrer	1021038	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Trevin	1021039	16	80.95	Trevin	221.5	Trevin
27	Trevin	1021039	0	1.4	Trevin	1021039	21	72.35	Trevin	1021039	22	98.75	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Venro	1021040	12	49	Venro	281.6	Venro
28	Venro	1021040	1	9.4	Venro	1021040	18	138.1	Venro	1021040	21	134.1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
29	Sheldon	1021012	19	98.3	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
30	Myles	109527	10	31	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
31	JJ	108271	0	0.2	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
32	house	99	6	14.5	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
33	Ryan	100335	17	99.4	Blank	Blank	0	0	Blank	Blank	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	Blank	Blank	0	0	Blank	23.1	Blank
34	Blank	0	0	0	House	99	7	28.55	house	99	0	-9.25	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	house	99	2	3.8	house	14.5	house
Custom Data Gathered

Cell Formulas
Range	Formula
A21:B34	A21	=Jan!A21
C21:C34	C21	=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C21:AG21,">.9")
D21:D34	D21	=SUMIFS(Jan!A21:AG21,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E21:F34	E21	=Feb!A21
G21:G34	G21	=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C21:AG21,">.9")
H21:H34	H21	=SUMIFS(Feb!A21:AG21,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I21:J34	I21	=Mar!A21
K21:K34	K21	=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C21:AG21,">.9")
L21:L34	L21	=SUMIFS(Mar!A21:AG21,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M21:N34	M21	=Apr!A21
O21:O34	O21	=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C21:AG21,">.9")
P21:P34	P21	=SUMIFS(Apr!A21:AG21,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q21:R34	Q21	=May!A21
S21:S34	S21	=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C21:AG21,">.9")
T21:T34	T21	=SUMIFS(May!A21:AG21,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U21:V34	U21	=Jun!A21
W21:W34	W21	=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C21:AG21,">.9")
X21:X34	X21	=SUMIFS(Jun!A21:AG21,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y21:Z34	Y21	=Jul!A21
AA21:AA34	AA21	=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C21:AG21,">.9")
AB21:AB34	AB21	=SUMIFS(Jul!A21:AG21,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC21:AD34	AC21	=Aug!A21
AE21:AE34	AE21	=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C21:AG21,">.9")
AF21:AF34	AF21	=SUMIFS(Aug!A21:AG21,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG21:AH34	AG21	=Sep!A21
AI21:AI34	AI21	=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C21:AG21,">.9")
AJ21:AJ34	AJ21	=SUMIFS(Sep!A21:AG21,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK21:AL34	AK21	=Oct!A21
AM21:AM34	AM21	=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C21:AG21,">.9")
AN21:AN34	AN21	=SUMIFS(Oct!A21:AG21,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO21:AP34	AO21	=Nov!A21
AQ21:AQ34	AQ21	=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C21:AG21,">.9")
AR21:AR34	AR21	=SUMIFS(Nov!A21:AG21,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS21:AT34	AS21	=Dec!A21
AU21:AU34	AU21	=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C21:AG21,">.9")
AV21:AV34	AV21	=SUMIFS(Dec!A21:AG21,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW21:AW34,BA21:BA34,BC21:BC34	AW21	='Aggregated Data'!$A21
AX21:AX34	AX21	='Aggregated Data'!B21
AY21:AY34	AY21	=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C21:AG21,">.9")
AZ21:AZ34	AZ21	=SUMIFS('Aggregated Data'!C21:AG21,'Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1)

im not sure if i am messing up the application of you formula but cell BB27 is the best example of the difficulties i am having finding a solution. the name venro in BA27 is the criteria that i need to match but that name shows in both rows 27 and 28. also i am not sure why i am getting errors in BB21 and BB22 when there is a match in AW21 and AW22

 

[Cubist]

There are no Kedrin or Miguel in Column A.