SUMIF
Hi
I am using the below formula to count cells in Sheet1!A2:A5432 which do not start with 30. How could I sum these values? =SUMPRODUCT((LEFT(Sheet1!A2:A5432,2)<"30")*1) TIA |
Hi Edgar
one way =SUMPRODUCT((LEFT(Sheet1!A2:A5432,2)<"30")*Sheet1 !A2:A5432) Cheers JulieD "Edgar Thoemmes" wrote in message ... Hi I am using the below formula to count cells in Sheet1!A2:A5432 which do not start with 30. How could I sum these values? =SUMPRODUCT((LEFT(Sheet1!A2:A5432,2)<"30")*1) TIA |
All times are GMT +1. The time now is 09:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com