M
Melody
Any help with the following will be appreciated
I have 3 cells with validation lists that match codes entered on a data sheet
A B
1 validation list 1 validation list 2 validation list
2 Name Amoun
3 Formula entered her
I want to sum other worksheet D1
10 if (other worksheet B1:B10=A3) and (other worksheet E1:E10=A1) and (other worksheet F1:F10=B1) and (other worksheet G1:G10=C1). (The search narrows with each validation list entry, but if any are blank the search broadens. If A1, B1, C1 are all blank it would return the sum for what matches (other worksheet B1:B10=A2)
I have =SUMPRODUCT(--(other worksheet B1:B10=A2)*(other worksheet E1:E10=A1)*(other worksheet F1:F10=B1)* (other worksheet G1:G10=C1),other worksheet D110) but this only works when all three validation list are used
I hope someone understands what I’m looking for. Thanks for your help if you do
I have 3 cells with validation lists that match codes entered on a data sheet
A B
1 validation list 1 validation list 2 validation list
2 Name Amoun
3 Formula entered her
I want to sum other worksheet D1
10 if (other worksheet B1:B10=A3) and (other worksheet E1:E10=A1) and (other worksheet F1:F10=B1) and (other worksheet G1:G10=C1). (The search narrows with each validation list entry, but if any are blank the search broadens. If A1, B1, C1 are all blank it would return the sum for what matches (other worksheet B1:B10=A2)I have =SUMPRODUCT(--(other worksheet B1:B10=A2)*(other worksheet E1:E10=A1)*(other worksheet F1:F10=B1)* (other worksheet G1:G10=C1),other worksheet D1
10) but this only works when all three validation list are usedI hope someone understands what I’m looking for. Thanks for your help if you do