![]() |
Conditional Add Formula
I have figured out how to set conditions to add amounts based on complete
cell values. What I want to know is if I can set a condition that will add a specified cell if another cell contains a certain value. For example. I have a cell with numbers and text which reads something like 075555 AAAAAAAAA... and another cell in that column which reads 375555 BBBBBBB. What I want is for the formula to pick up the first two numbers only. So 07 and 37 (as I could have multiple descriptions in that column but the descriptions will always start with either 07 and 37). I want the sum of the descriptions starting with 07 and the sum of the descriptions starting with 37. Is there a way to do this? |
All times are GMT +1. The time now is 02:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com