Is it possible to use the sumif function based on the criteria of.

G

Guest

I want to be able to sumif based on highlight color in one spreadsheet I use
In another, I want rows to link to other sheets based on the highlight
color...
Am I nuts?
 
J

JulieD

"nuts" maybe a bit too strong - i'ld go for "ambitious" :)

SUMIF and linking are two different things.. so i'm not sure if there's one
question here or two - however, for a lot of ideas on using colours for
summing / counting / sorting etc check out
http://www.cpearson.com/excel/colors.htm

Let us know if this answers your question(s).

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top