Sum if with left function
Solved
salsero75014
Posted messages
35
Status
Member
-
Excel13 -
Excel13 -
Hello,
I would like to sum the products in column H only if column B contains the expression "S/Total R2017"
I tried this:
=SUMIF(B12:B659;"LEFT(S/Total R2017/20652;13)";H12:H659)
But it gives me zero
Thank you
Configuration: Windows / Firefox 45.0
5 answers
Hello
so if you use SUMIFS
(or anything like SUMIF / COUNTIF etc...
but under no circumstances can you search for text longer than what is written in the column, which seems to be the case in your example
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
so if you use SUMIFS
(or anything like SUMIF / COUNTIF etc...
- either the sought code is entirely and solely written in the column, you can write: "text"
- or the code is written anywhere in the text of the column, which gives "*text*"
- or you want the text at the beginning of that column "text*"
- or at the end:"*text"
but under no circumstances can you search for text longer than what is written in the column, which seems to be the case in your example
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
Excel13
Thank you @Vaucluse
