Excel problem View previous topic :: View next topic  


NFOHump.com Forum Index - Applications
Page 1 of 1
PDSOUNDS




Posts: 318
PostPosted: Thu, 8th Feb 2007 20:12    Post subject: Excel problem
I have a small problem, but nobody knows the answer, so I have a big excel problem.

I have a row of numbers, some of theme are RED others are black.
is there a way to add up all the red numbers or all the black numbers?
So he must sort the colors to count them up.

Somebody????

Thnx
Question
Back to top
nouseforaname
Über-VIP Member



Posts: 21306
Location: Toronto, Canada
PostPosted: Thu, 8th Feb 2007 20:25    Post subject:
http://www.cpearson.com/excel/colors.htm
http://www.ozgrid.com/VBA/Sum.htm

has your answer Wink

asus z170-A || core i5-6600K || geforce gtx 970 4gb || 16gb ddr4 ram || win10 || 1080p led samsung 27"
Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Applications
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group