adding cells based on criteria across several columns

J

jbrown021286

Board Regular
Joined
Mar 13, 2023
Messages
65
Office Version
  1. 365
Platform
  1. Windows
TECH HOURS WORKSHEET 6.0 test.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
11-Jan22-Apr
2NameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours ProducedNameNumberDays WorkedHours Produced
3JanFebMarAprMayJunJulAugSepOctNovDecCurrentTotal hoursTotal Days Worked
4Jeff10150215207.2Jeff10150222264.1Jeff10150223311.25000000000000000000000000000000000000Jeff10150216227.35JeffJeff
5Justin10154923188.5Justin10154920170.9Justin10154924240.9000000000000000000000000000000000000Justin10154916189.9JustinJustin
6Ramy10364220182.8Ramy10364217152.4Ramy10364225365.3000000000000000000000000000000000000Ramy10364216208.65RamyRamy
7Tuzzo10713219-547Tuzzo10713222136.5Tuzzo10713217100.65000000000000000000000000000000000000Tuzzo107132643TuzzoTuzzo
8Brandun10747124198.1Brandun1074711187.1Brandun107471976.65000000000000000000000000000000000000Brandun10747116125.25BrandunBrandun
9Carl10780119143.1Carl10780118153.5Carl10780119240.6000000000000000000000000000000000000Carl10780118128.25CarlCarl
10Rod Jones1082281536.7Rod Jones1082281651.8Rod Jones1082281766.6000000000000000000000000000000000000Rod Jones1082281334.6Rod JonesRod Jones
11Que 1082432491.4Que 10824323108.05Que 10824322135.4000000000000000000000000000000000000Que 10824316102.6Que Que
12James10841023154.35James10841023166.25James10841024200.5000000000000000000000000000000000000James10841017102.7JamesJames
13Owens10863421155.4Owens10863420175.8Owens10863422208.5000000000000000000000000000000000000Owens10863413111OwensOwens
14Hawk10954323119.8Hawk10954324201.1Hawk10954312.6000000000000000000000000000000000000Brandun Mcghee10210451553.5Brandun McgheeBrandun Mcghee
15Josh10957220163.8Josh10957221200.4Josh10957223227.3000000000000000000000000000000000000Josh1095721296.55JoshJosh
16David1097831983.9David10978319122.8David10978319152.75000000000000000000000000000000000000David1097831365.5DavidDavid
Custom Data Gathered
Cell Formulas
RangeFormula
A1:B1A1='Custom Hours'!D6
A4:B16A4=Jan!A4
C4:C16C4=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C4:AG4,">.9")
D4:D16D4=SUMIFS(Jan!A4:AG4,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E4:F16E4=Feb!A4
G4:G16G4=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C4:AG4,">.9")
H4:H16H4=SUMIFS(Feb!A4:AG4,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I4:J16I4=Mar!A4
K4:K16K4=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C4:AG4,">.9")
L4:L16L4=SUMIFS(Mar!A4:AG4,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M4:N16M4=Apr!A4
O4:O16O4=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C4:AG4,">.9")
P4:P16P4=SUMIFS(Apr!A4:AG4,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q4:R16Q4=May!A4
S4:S16S4=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C4:AG4,">.9")
T4:T16T4=SUMIFS(May!A4:AG4,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U4:V16U4=Jun!A4
W4:W16W4=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C4:AG4,">.9")
X4:X16X4=SUMIFS(Jun!A4:AG4,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y4:Z16Y4=Jul!A4
AA4:AA16AA4=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C4:AG4,">.9")
AB4:AB16AB4=SUMIFS(Jul!A4:AG4,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC4:AD16AC4=Aug!A4
AE4:AE16AE4=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C4:AG4,">.9")
AF4:AF16AF4=SUMIFS(Aug!A4:AG4,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG4:AH16AG4=Sep!A4
AI4:AI16AI4=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C4:AG4,">.9")
AJ4:AJ16AJ4=SUMIFS(Sep!A4:AG4,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK4:AL16AK4=Oct!A4
AM4:AM16AM4=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C4:AG4,">.9")
AN4:AN16AN4=SUMIFS(Oct!A4:AG4,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO4:AP16AO4=Nov!A4
AQ4:AQ16AQ4=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C4:AG4,">.9")
AR4:AR16AR4=SUMIFS(Nov!A4:AG4,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS4:AT16AS4=Dec!A4
AU4:AU16AU4=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C4:AG4,">.9")
AV4:AV16AV4=SUMIFS(Dec!A4:AG4,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW4:AW16,BA4:BA16,BC4:BC16AW4='Aggregated Data'!$A4
AX4:AX16AX4='Aggregated Data'!B4
AY4:AY16AY4=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C4:AG4,">.9")
AZ4:AZ16AZ4=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.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
Try:
Excel Formula: 
=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))
 
Upvote 0
Cubist said:
Try:
Excel Formula: 
=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))[/C
[/QUOTE]
Click to expand...

Cubist said:
Try:
Excel Formula: 
=BYROW(FILTER(A4:AZ16,A2:AZ2="Hours Produced"),LAMBDA(br,SUM(br)))
Click to expand...
TECH HOURS WORKSHEET 6.0 test.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
22Jerusha10210282055.4Jerusha10210282048.9Jerusha102102849.6000000000000000000000000000000000000Miguel10369914182.45Miguel296.35Miguel
23Gerrardo 10210292271.5Gerrardo 10210292081.2Gerrardo 102102921126.7000000000000000000000000000000000000Gerrardo 102102914103.85Gerrardo 383.25Gerrardo
24Tre10210321555.2Tre10210322280.25Tre102103221102.95000000000000000000000000000000000000Tre10210321668.6Tre307Tre
25Harry1021037716.7Harry10210371959.3Harry10210372166000000000000000000000000000000000000Harry10210371559.2Harry201.2Harry
26Contrer102103837.3Contrer102103846.6Contrer102103800000000000000000000000000000000000000Trevin10210391680.95Trevin94.85Trevin
27Trevin102103901.4Trevin10210392172.35Trevin10210392298.75000000000000000000000000000000000000Venro10210401249Venro221.5Venro
28Venro102104019.4Venro102104018138.1Venro102104021134.1000000000000000000000000000000000000BlankBlank00Blank281.6Blank
29Sheldon10210121998.3BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank98.3Blank
30Myles1095271031BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank31Blank
31JJ10827100.2BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank0.2Blank
32house99614.5BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank14.5Blank
33Ryan1003351799.4BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank99.4Blank
34Blank000House99728.55house990-9.25000000000000000000000000000000000000house9923.8house23.1house
Custom Data Gathered
Cell Formulas
RangeFormula
A22:B34A22=Jan!A22
C22:C34C22=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C22:AG22,">.9")
D22:D34D22=SUMIFS(Jan!A22:AG22,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E22:F34E22=Feb!A22
G22:G34G22=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C22:AG22,">.9")
H22:H34H22=SUMIFS(Feb!A22:AG22,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I22:J34I22=Mar!A22
K22:K34K22=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C22:AG22,">.9")
L22:L34L22=SUMIFS(Mar!A22:AG22,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M22:N34M22=Apr!A22
O22:O34O22=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C22:AG22,">.9")
P22:P34P22=SUMIFS(Apr!A22:AG22,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q22:R34Q22=May!A22
S22:S34S22=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C22:AG22,">.9")
T22:T34T22=SUMIFS(May!A22:AG22,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U22:V34U22=Jun!A22
W22:W34W22=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C22:AG22,">.9")
X22:X34X22=SUMIFS(Jun!A22:AG22,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y22:Z34Y22=Jul!A22
AA22:AA34AA22=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C22:AG22,">.9")
AB22:AB34AB22=SUMIFS(Jul!A22:AG22,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC22:AD34AC22=Aug!A22
AE22:AE34AE22=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C22:AG22,">.9")
AF22:AF34AF22=SUMIFS(Aug!A22:AG22,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG22:AH34AG22=Sep!A22
AI22:AI34AI22=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C22:AG22,">.9")
AJ22:AJ34AJ22=SUMIFS(Sep!A22:AG22,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK22:AL34AK22=Oct!A22
AM22:AM34AM22=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C22:AG22,">.9")
AN22:AN34AN22=SUMIFS(Oct!A22:AG22,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO22:AP34AO22=Nov!A22
AQ22:AQ34AQ22=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C22:AG22,">.9")
AR22:AR34AR22=SUMIFS(Nov!A22:AG22,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS22:AT34AS22=Dec!A22
AU22:AU34AU22=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C22:AG22,">.9")
AV22:AV34AV22=SUMIFS(Dec!A22:AG22,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW22:AW34,BA22:BA34,BC22:BC34AW22='Aggregated Data'!$A22
AX22:AX34AX22='Aggregated Data'!B22
AY22:AY34AY22=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C22:AG22,">.9")
AZ22:AZ34AZ22=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
 
Upvote 0
In the OP, in column BA, you referenced column A so misleading. Try
Excel Formula: 
=BYROW(BA3:BA15,LAMBDA(br,SUM(FILTER(FILTER(A3:AZ15,A2:AZ2="Hours Produced"),A3:A15=br))))
 
Upvote 0
Cubist said:
In the OP, in column BA, you referenced column A so misleading. Try
Excel Formula: 
=BYROW(BA3:BA15,LAMBDA(br,SUM(FILTER(FILTER(A3:AZ15,A2:AZ2="Hours Produced"),A3:A15=br))))
Click to expand...
TECH HOURS WORKSHEET 6.0 test.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBD
21Frederick102102719105.6Frederick102102720168.5Frederick10210271068.2000000000000000000000000000000000000Kedrin1021054425.2Kedrin#CALC!Kedrin
22Jerusha10210282055.4Jerusha10210282048.9Jerusha102102849.6000000000000000000000000000000000000Miguel10369914182.45Miguel#CALC!Miguel
23Gerrardo 10210292271.5Gerrardo 10210292081.2Gerrardo 102102921126.7000000000000000000000000000000000000Gerrardo 102102914103.85Gerrardo 383.25Gerrardo
24Tre10210321555.2Tre10210322280.25Tre102103221102.95000000000000000000000000000000000000Tre10210321668.6Tre307Tre
25Harry1021037716.7Harry10210371959.3Harry10210372166000000000000000000000000000000000000Harry10210371559.2Harry201.2Harry
26Contrer102103837.3Contrer102103846.6Contrer102103800000000000000000000000000000000000000Trevin10210391680.95Trevin221.5Trevin
27Trevin102103901.4Trevin10210392172.35Trevin10210392298.75000000000000000000000000000000000000Venro10210401249Venro281.6Venro
28Venro102104019.4Venro102104018138.1Venro102104021134.1000000000000000000000000000000000000BlankBlank00Blank23.1Blank
29Sheldon10210121998.3BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank23.1Blank
30Myles1095271031BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank23.1Blank
31JJ10827100.2BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank23.1Blank
32house99614.5BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank23.1Blank
33Ryan1003351799.4BlankBlank00BlankBlank00000000000000000000000000000000000000BlankBlank00Blank23.1Blank
34Blank000House99728.55house990-9.25000000000000000000000000000000000000house9923.8house14.5house
Custom Data Gathered
Cell Formulas
RangeFormula
A21:B34A21=Jan!A21
C21:C34C21=COUNTIFS(Jan!$C$3:$AG$3,">="&$A$1,Jan!$C$3:$AG$3,"<="&$B$1,Jan!C21:AG21,">.9")
D21:D34D21=SUMIFS(Jan!A21:AG21,Jan!$A$3:$AG$3,">="&$A$1,Jan!$A$3:$AG$3,"<="&$B$1)
E21:F34E21=Feb!A21
G21:G34G21=COUNTIFS(Feb!$C$3:$AG$3,">="&$A$1,Feb!$C$3:$AG$3,"<="&$B$1,Feb!C21:AG21,">.9")
H21:H34H21=SUMIFS(Feb!A21:AG21,Feb!$A$3:$AG$3,">="&$A$1,Feb!$A$3:$AG$3,"<="&$B$1)
I21:J34I21=Mar!A21
K21:K34K21=COUNTIFS(Mar!$C$3:$AG$3,">="&$A$1,Mar!$C$3:$AG$3,"<="&$B$1,Mar!C21:AG21,">.9")
L21:L34L21=SUMIFS(Mar!A21:AG21,Mar!$A$3:$AG$3,">="&$A$1,Mar!$A$3:$AG$3,"<="&$B$1)
M21:N34M21=Apr!A21
O21:O34O21=COUNTIFS(Apr!$C$3:$AG$3,">="&$A$1,Apr!$C$3:$AG$3,"<="&$B$1,Apr!C21:AG21,">.9")
P21:P34P21=SUMIFS(Apr!A21:AG21,Apr!$A$3:$AG$3,">="&$A$1,Apr!$A$3:$AG$3,"<="&$B$1)
Q21:R34Q21=May!A21
S21:S34S21=COUNTIFS(May!$C$3:$AG$3,">="&$A$1,May!$C$3:$AG$3,"<="&$B$1,May!C21:AG21,">.9")
T21:T34T21=SUMIFS(May!A21:AG21,May!$A$3:$AG$3,">="&$A$1,May!$A$3:$AG$3,"<="&$B$1)
U21:V34U21=Jun!A21
W21:W34W21=COUNTIFS(Jun!$C$3:$AG$3,">="&$A$1,Jun!$C$3:$AG$3,"<="&$B$1,Jun!C21:AG21,">.9")
X21:X34X21=SUMIFS(Jun!A21:AG21,Jun!$A$3:$AG$3,">="&$A$1,Jun!$A$3:$AG$3,"<="&$B$1)
Y21:Z34Y21=Jul!A21
AA21:AA34AA21=COUNTIFS(Jul!$C$3:$AG$3,">="&$A$1,Jul!$C$3:$AG$3,"<="&$B$1,Jul!C21:AG21,">.9")
AB21:AB34AB21=SUMIFS(Jul!A21:AG21,Jul!$A$3:$AG$3,">="&$A$1,Jul!$A$3:$AG$3,"<="&$B$1)
AC21:AD34AC21=Aug!A21
AE21:AE34AE21=COUNTIFS(Aug!$C$3:$AG$3,">="&$A$1,Aug!$C$3:$AG$3,"<="&$B$1,Aug!C21:AG21,">.9")
AF21:AF34AF21=SUMIFS(Aug!A21:AG21,Aug!$A$3:$AG$3,">="&$A$1,Aug!$A$3:$AG$3,"<="&$B$1)
AG21:AH34AG21=Sep!A21
AI21:AI34AI21=COUNTIFS(Sep!$C$3:$AG$3,">="&$A$1,Sep!$C$3:$AG$3,"<="&$B$1,Sep!C21:AG21,">.9")
AJ21:AJ34AJ21=SUMIFS(Sep!A21:AG21,Sep!$A$3:$AG$3,">="&$A$1,Sep!$A$3:$AG$3,"<="&$B$1)
AK21:AL34AK21=Oct!A21
AM21:AM34AM21=COUNTIFS(Oct!$C$3:$AG$3,">="&$A$1,Oct!$C$3:$AG$3,"<="&$B$1,Oct!C21:AG21,">.9")
AN21:AN34AN21=SUMIFS(Oct!A21:AG21,Oct!$A$3:$AG$3,">="&$A$1,Oct!$A$3:$AG$3,"<="&$B$1)
AO21:AP34AO21=Nov!A21
AQ21:AQ34AQ21=COUNTIFS(Nov!$C$3:$AG$3,">="&$A$1,Nov!$C$3:$AG$3,"<="&$B$1,Nov!C21:AG21,">.9")
AR21:AR34AR21=SUMIFS(Nov!A21:AG21,Nov!$A$3:$AG$3,">="&$A$1,Nov!$A$3:$AG$3,"<="&$B$1)
AS21:AT34AS21=Dec!A21
AU21:AU34AU21=COUNTIFS(Dec!$C$3:$AG$3,">="&$A$1,Dec!$C$3:$AG$3,"<="&$B$1,Dec!C21:AG21,">.9")
AV21:AV34AV21=SUMIFS(Dec!A21:AG21,Dec!$A$3:$AG$3,">="&$A$1,Dec!$A$3:$AG$3,"<="&$B$1)
AW21:AW34,BA21:BA34,BC21:BC34AW21='Aggregated Data'!$A21
AX21:AX34AX21='Aggregated Data'!B21
AY21:AY34AY21=COUNTIFS('Aggregated Data'!$C$3:$AG$3,">="&$A$1,'Aggregated Data'!$C$3:$AG$3,"<="&$B$1,'Aggregated Data'!C21:AG21,">.9")
AZ21:AZ34AZ21=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
 
Upvote 0
There are no Kedrin or Miguel in Column A.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Solved
help finding my error
Replies
1
Views
194
Proulxs
P
J
  • Solved
populating dates of the current month with a formula
Replies
6
Views
112
jbrown021286
J
nburaq
  • Solved
Conditional Formatting last n rows as data entered
Replies
6
Views
137
Fluff
Fluff
S
  • Solved
lookup return from range of dates
Replies
4
Views
229
Peter_SSs
Peter_SSs
M
  • Solved
How to count certain month from a column
Replies
3
Views
196
Joe4
Joe4

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top