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,



2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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