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
j1969c Posts 20 Registration date Friday August 28, 2015 Status Member Last seen April 5, 2016 - Sep 11, 2015 at 07:49 PM
Related:
- My compliments, great altruism everybody! Great forum!
- Candy crush forum - Android Forum
- Chrome help forum - Viruses & Security Forum
- Setcom forum - Software Forum
- Regedit forum - Network Forum
- Yahoo help forum - Yahoo Mail Forum
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
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
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
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 11, 2015 at 04:26 PM
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
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
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
Sep 11, 2015 at 07:49 PM
Sep 11, 2015 at 07:49 PM
Works like a charm! Thank you, thank you, thank you...
Sep 11, 2015 at 02:11 PM
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"