Question description:
This user has given permission to use the problem statement for this
blog.
I want a column to total all the black numbers in another column, not the red ones.
Solved by K. L. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
10/02/2018 - 10:35
Hi
User
10/02/2018 - 10:35
Hi there!
Excelchat Expert
10/02/2018 - 10:35
Do you have a file to wok on?
User
10/02/2018 - 10:36
I can show you what I'm doing on this preview window....
Excelchat Expert
10/02/2018 - 10:38
we need to create a custom function for this
User
10/02/2018 - 10:39
sweet!
Excelchat Expert
10/02/2018 - 10:40
the color will be font based?
Excelchat Expert
10/02/2018 - 10:40
or color of cell?
User
10/02/2018 - 10:41
the font base
Excelchat Expert
10/02/2018 - 10:44
Here
Excelchat Expert
10/02/2018 - 10:44
https://www.dropbox.com/s/8vvmtogacuaz976/sum_color_Font_or_Interior.xlsm?dl=0
Excelchat Expert
10/02/2018 - 10:45
download this file
Excelchat Expert
10/02/2018 - 10:45
open and enable contnet
Excelchat Expert
10/02/2018 - 10:45
then tell me
Excelchat Expert
10/02/2018 - 10:46
done so?
User
10/02/2018 - 10:46
yes I downloaded it
Excelchat Expert
10/02/2018 - 10:47
Ok check in C4
User
10/02/2018 - 10:47
so you put sumbycolor, then select the cell with the correct color? then put the cell range in?
Excelchat Expert
10/02/2018 - 10:47
yes
Excelchat Expert
10/02/2018 - 10:47
exactly
User
10/02/2018 - 10:47
awesome! let me try it
Excelchat Expert
10/02/2018 - 10:47
sure
Excelchat Expert
10/02/2018 - 10:48
dont try this in google sheet
Excelchat Expert
10/02/2018 - 10:48
it will not work
Excelchat Expert
10/02/2018 - 10:48
As custom function means macro, which only works in excel
User
10/02/2018 - 10:48
ok. I also just tried in on my excel document, but it didn't work there. unknown function as well
Excelchat Expert
10/02/2018 - 10:49
You can only try it on the file I have sent you
Excelchat Expert
10/02/2018 - 10:49
The macro I created exists only in my file
User
10/02/2018 - 10:50
oh I see.
User
10/02/2018 - 10:50
is it possible for me to make my own macro?
Excelchat Expert
10/02/2018 - 10:50
You can copy my macro and paste it in your file
User
10/02/2018 - 10:51
as in the cell function?
Excelchat Expert
10/02/2018 - 10:51
no
Excelchat Expert
10/02/2018 - 10:51
in my file
Excelchat Expert
10/02/2018 - 10:51
go to developer->visual basic
User
10/02/2018 - 10:52
where is developer?
Excelchat Expert
10/02/2018 - 10:52
[Uploaded an Excel file]
Excelchat Expert
10/02/2018 - 10:53
[Uploaded an Excel file]
Excelchat Expert
10/02/2018 - 10:53
first look at the second picture
Excelchat Expert
10/02/2018 - 10:53
then first one
Excelchat Expert
10/02/2018 - 10:54
ok?
User
10/02/2018 - 10:54
I don't have that tab...
Excelchat Expert
10/02/2018 - 10:55
Oh that is not enabled may be
User
10/02/2018 - 10:55
where do I enable that?
Excelchat Expert
10/02/2018 - 10:56
Goto File->Options->Add ins
Excelchat Expert
10/02/2018 - 10:57
look for this
[Uploaded an Excel file]
User
10/02/2018 - 10:57
that's where I was haha!
User
10/02/2018 - 10:57
analysis toolpak?
User
10/02/2018 - 10:58
or toolpak VBA?
Excelchat Expert
10/02/2018 - 10:58
vba
User
10/02/2018 - 10:59
I selected it... how do I enable it?
User
10/02/2018 - 11:00
its just listed as inactive
Excelchat Expert
10/02/2018 - 11:01
It should be activated in the main menu list now
User
10/02/2018 - 11:01
ok I made it active...
Excelchat Expert
10/02/2018 - 11:02
then open my file
Excelchat Expert
10/02/2018 - 11:02
If the file says "enable content"...enable
User
10/02/2018 - 11:03
haha! I got it. I had to make that tab visible in options -> customize ribbons
Excelchat Expert
10/02/2018 - 11:03
great
Excelchat Expert
10/02/2018 - 11:03
now goto developer->visual basic
Excelchat Expert
10/02/2018 - 11:03
in my file
Excelchat Expert
10/02/2018 - 11:04
you will see a script in there(module 1)
User
10/02/2018 - 11:04
ok!
User
10/02/2018 - 11:04
I see it
Excelchat Expert
10/02/2018 - 11:06
Now in your file you need to copy this scrpit...in developer tab....visyal basic...module...
Excelchat Expert
10/02/2018 - 11:06
then save your file as xlsm
User
10/02/2018 - 11:08
when I go to my file and click on visual basic it just opens up yours automatically
Excelchat Expert
10/02/2018 - 11:09
copy my scrpit some where else in a doc file
Excelchat Expert
10/02/2018 - 11:09
then close all the excel sheets
Excelchat Expert
10/02/2018 - 11:09
then open your file
User
10/02/2018 - 11:09
ok
User
10/02/2018 - 11:11
ok I opened up visual basic
Excelchat Expert
10/02/2018 - 11:11
go to module
User
10/02/2018 - 11:11
where is that...
Excelchat Expert
10/02/2018 - 11:12
[Uploaded an Excel file]
User
10/02/2018 - 11:12
under VBAproject?
Excelchat Expert
10/02/2018 - 11:12
here
[Uploaded an Excel file]
Excelchat Expert
10/02/2018 - 11:12
have you got the picture
User
10/02/2018 - 11:13
yes thank you! just a sec
User
10/02/2018 - 11:14
when I click on module, what is supposed to happen?
Excelchat Expert
10/02/2018 - 11:14
paste my code there
User
10/02/2018 - 11:15
it has a RibbonX_code under module
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
