ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Sum (https://www.excelbanter.com/excel-worksheet-functions/191048-conditional-sum.html)

Vernon

Conditional Sum
 
Is it possible to change an autosum function at the bottom of a column to add
only those cells in the range that are a certain color, or font color?

Susan

Conditional Sum
 
http://groups.google.com/group/micro... a392fc6cec62

this thread contains a couple of suggestions.
hope it helps
susan


On Jun 12, 3:23*pm, Vernon wrote:
Is it possible to change an autosum function at the bottom of a column to add
only those cells in the range that are a certain color, or font color?



Vernon

Conditional Sum
 
I checked these out but couldn't get either one to work. Thanks though.

"Susan" wrote:

http://groups.google.com/group/micro... a392fc6cec62

this thread contains a couple of suggestions.
hope it helps
susan


On Jun 12, 3:23 pm, Vernon wrote:
Is it possible to change an autosum function at the bottom of a column to add
only those cells in the range that are a certain color, or font color?





All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com