H Hilton Aug 29, 2008 #1 Hi, can I use wildcards with sumproduct? eg 3A22 8 3B11 6 3B12 12 Would like agrregate 3B11 & 3B12 3B = 18 Thanks
Hi, can I use wildcards with sumproduct? eg 3A22 8 3B11 6 3B12 12 Would like agrregate 3B11 & 3B12 3B = 18 Thanks
J JLatham Aug 29, 2008 #2 Not wild card, but you can use regular string functions. Try this: =SUMPRODUCT(--(LEFT(A1:A3,2)="3B"),--(B1:B3))
Not wild card, but you can use regular string functions. Try this: =SUMPRODUCT(--(LEFT(A1:A3,2)="3B"),--(B1:B3))
P Pete_UK Aug 29, 2008 #3 In this case you would use a condition like: (LEFT(A1:A100,2)="3B") so you probably want something like: =SUMPRODUCT(--(LEFT(A1:A100,2)="3B"),B1:B100) Hope this helps. Pete
In this case you would use a condition like: (LEFT(A1:A100,2)="3B") so you probably want something like: =SUMPRODUCT(--(LEFT(A1:A100,2)="3B"),B1:B100) Hope this helps. Pete
B Bob Phillips Aug 29, 2008 #4 What's wrong with =SUMIF(A:A,"3B*",B:B) Not a SUMPRODUCT in sight -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
What's wrong with =SUMIF(A:A,"3B*",B:B) Not a SUMPRODUCT in sight -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
B Bob Phillips Aug 29, 2008 #6 He did Pete, but we can set him right <g> -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Well, Bob, the OP did specifically ask about sumproduct !! <bg> Pete
He did Pete, but we can set him right <g> -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) Well, Bob, the OP did specifically ask about sumproduct !! <bg> Pete
