J
JeffTO
Hi All
I know how to use the conditional sum or sumif function - I am trying
to see if there is a better way to do somethign that works wth sumif -
but there really is no "summing" going on - and since I use a lot of
these in a spreadhsheet and it takes more time than I would like to
process I am looking for a potential alternative.
Anyone have any other ideas that might be more efficient than using a
SumIf if there is no "summing" actually going on - it is sort of like
a lookup inside a lookup but since I done have the middle range needed
for the 2nd lookup I am not sure what to do
Thanks in advance for any assistance
Jeff
Here is what I have
Value Formua Result
A SUM(IF(IDList=ID,IF(Code=A2,Count,0))) 100
B SUM(IF(IDList=ID,IF(Code=A3,Count,0))) 0
C SUM(IF(IDList=ID,IF(Code=A4,Count,0))) 100
D SUM(IF(IDList=ID,IF(Code=A5,Count,0))) 100
E SUM(IF(IDList=ID,IF(Code=A6,Count,0))) 0
F SUM(IF(IDList=ID,IF(Code=A7,Count,0))) 100
ID = 22222
IDList Code Count
11111 A 100
11111 B 100
11111 C 100
11111 D 100
11111 E 100
11111 F 100
22222 A 100
22222 C 100
22222 D 100
22222 F 100
33333 B 100
33333 D 100
33333 E 100
44444 A 100
44444 B 100
44444 C 100
44444 D 100
44444 E 100
44444 F 100
55555 A 100
55555 B 100
55555 C 100
55555 D 100
55555 E 100
55555 F 100
I know how to use the conditional sum or sumif function - I am trying
to see if there is a better way to do somethign that works wth sumif -
but there really is no "summing" going on - and since I use a lot of
these in a spreadhsheet and it takes more time than I would like to
process I am looking for a potential alternative.
Anyone have any other ideas that might be more efficient than using a
SumIf if there is no "summing" actually going on - it is sort of like
a lookup inside a lookup but since I done have the middle range needed
for the 2nd lookup I am not sure what to do
Thanks in advance for any assistance
Jeff
Here is what I have
Value Formua Result
A SUM(IF(IDList=ID,IF(Code=A2,Count,0))) 100
B SUM(IF(IDList=ID,IF(Code=A3,Count,0))) 0
C SUM(IF(IDList=ID,IF(Code=A4,Count,0))) 100
D SUM(IF(IDList=ID,IF(Code=A5,Count,0))) 100
E SUM(IF(IDList=ID,IF(Code=A6,Count,0))) 0
F SUM(IF(IDList=ID,IF(Code=A7,Count,0))) 100
ID = 22222
IDList Code Count
11111 A 100
11111 B 100
11111 C 100
11111 D 100
11111 E 100
11111 F 100
22222 A 100
22222 C 100
22222 D 100
22222 F 100
33333 B 100
33333 D 100
33333 E 100
44444 A 100
44444 B 100
44444 C 100
44444 D 100
44444 E 100
44444 F 100
55555 A 100
55555 B 100
55555 C 100
55555 D 100
55555 E 100
55555 F 100