Sumif by color

[brandedadnan]

hello guys,

Is it possible to have a forumlae based on cell color, background being green,

I tried searching online. they always give confusing vb editor codes.

Thats why i need a simple forumlae with color being green

Best Rgds
AT

[adhawan06]

Hi Brand,

You can have it but for that you must need one helper column (assuming you are formatting cell based on some value and then you want other cell to change as per color formatting).

Regards,
Anil

[TMS]

No. Colour is not data. That's why people have developed VBA routines.

You can filter by colour and SUBTOTAL will exclude hidden row so you could maybe use that as a workaround.

Regards, TMS

[Jacc]

No formula will do that. You can use Autofilter and filter by color and then use SUBTOTAL(109.

If that's not good enough then this UDF will do it for you. Once you pasted the code it will be just like a new function in your workbook.
http://www.ozgrid.com/VBA/Sum.htm

Just post again if you have trouble with UDF and you will get guidance.

[:) Sixthsense :)]

How the cells are formatted?

Manually or Using Conditional Formatting?

If the formatting is not manual then surely we can Sum() the data

[Anh Trinh]

Is there any UDF to add value to cell based on its color? not sum but to add the value to cell.

Thank you,
TA

[brandedadnan]

Hi jacc,

I want to use sum by color function, So I am using attached function.
When i run it, it shows an error

Please chk n let me know

Thanks
AT

I am facing attached error

[brandedadnan]

Hi sixth sense,

The formatting is done on manual basis, pls suggest ur solution

Rgds
AT

[adhawan06]

@ Anh
Please read the forum rules carefully. You can not post question on someone else's post


Forum Rules
Please read and adhere to these simple rules!

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

Also, please continue with your open threads there only you will get answer for your query. . http://www.excelforum.com/excel-gene...und-color.html

[:) Sixthsense :)]

The formatting is done on manual basis, pls suggest ur solution

As described by other members you have to go for VBA approach only...

[Jacc]

You copied to far down, this part needs to be there as well:

Please Login or Register  to view this content.

or specifically the top row of it which is where you tell Excel that this is a function. The text preceeded by a ' is just comments made by the author, you can skip that.

[TMS]

Or AutoFilter and SUBTOTAL as I said earlier.

[brandedadnan]

Thanks Jacc, worked perfectly, I did not know u can add functions to excel as well.

Great learning curve,
Thanks all for ur efforts.
Rgds
AT

[Jacc]

''''''''

[Jacc]

-----------