Katy Jordan
Well-known Member
- Joined
- Jun 28, 2008
- Messages
- 596
Hi, i want to add trim to the interest as there are trailing spaces in the main data and the formula returns #VALUE, how can i do that,
=SUMPRODUCT((Sheet1!C1:C65000="INTEREST")*(Sheet1!D1:D65000))
=SUMPRODUCT((Sheet1!C1:C65000="INTEREST")*(Sheet1!D1:D65000))