My compliments, great altruism everybody! Great forum!

Solved/Closed
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Sep 11, 2015 at 11:40 AM
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Sep 11, 2015 at 07:49 PM
Hello, everybody in the forum!

My compliments for your unselfishness and altruism. Your help is VERY MUCH appreciated!

A big hello, especially to Mr Marcílio Lobão that has gone above and beyond the "call of duty" in his effort to help...

Many thanks,



Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 11, 2015 at 12:40 PM
j1969c, Good afternoon.

Thank you very much for your compliments.
I am always happy to help.

But remember that there are many other users here in this forum who always strive to use the free time to help people anywhere in the world.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Sep 11, 2015 at 02:11 PM
Unfortunately, your reply did not help, because I think I did not express myself well...

In cells from F9 to F46 there may be CTF or SAA or ASA etc...
In cells from I9 to I46 there may be $500 or $200 or $100 etc...

What I need is that every time any cell from F9 to F46 displays CTF I want cell I51 to display THE SUM of the dollar amount found in each cell from I9 to I46 as long as that in front of it [cell F] the acronym CTF is displayed, and leave alone (do not add) any other cell from I9 to I 46 if the [cell F] in front of it does not contain "CTF"
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 11, 2015 at 04:26 PM
j1969c, God afternoon.

This explanation shows that now you need another process.

I51 -->
=SUMIF(F9:F46,"CTF",I9:I46)

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 4
Sep 11, 2015 at 07:49 PM
Works like a charm! Thank you, thank you, thank you...
0