Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 698
- Office Version
- 2010
- Platform
- Windows
Hi:
I have serial numbers in column K and prices in column S.
I want to add all prices in column S for all serial numbers in column K that begin with 4010
The formula below is returning #Value!
=SUMPRODUCT((LEFT(K16:K48,4)+0=4010)*(S16:S48)).
Could you help please?
Regards,
Sean
I have serial numbers in column K and prices in column S.
I want to add all prices in column S for all serial numbers in column K that begin with 4010
The formula below is returning #Value!
=SUMPRODUCT((LEFT(K16:K48,4)+0=4010)*(S16:S48)).
Could you help please?
Regards,
Sean