ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add number from a cell that contains a specific character (https://www.excelbanter.com/excel-worksheet-functions/124781-add-number-cell-contains-specific-character.html)

Carole

Add number from a cell that contains a specific character
 
I want to look in a range of cells (a1:d1) add the left number for all that
meet the criteria (a or A). I have tried variations but have yet to get it
to add.

A B C D
1 2 C 2 a 2 S 2 A
2 1 c 2 A 1 LS 1 C

I need to leave the number and character in the same column with the space
between them.


All times are GMT +1. The time now is 07:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com