ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Add Formula (https://www.excelbanter.com/excel-discussion-misc-queries/241306-conditional-add-formula.html)

CountrySmiles

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