My compliments, great altruism everybody! Great forum! [Solved/Closed]

Report
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
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

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
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"
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
Works like a charm! Thank you, thank you, thank you...