Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I imported a set of Color Functions from http://cpearson.com/excel/colors.aspx
And I want to replace where I added COUNTIF in my sheet with a new function that will count in the specified range, using the specified criteria and if the color is red. So I thought that making an IF function that uses COUNT (replaced by CountColor to make it look for red cells) would do the trick. I kindof got stuck so any help is appreciated. I'd also like to modify this formula: =SUMPRODUCT(--('Intarzieri (2)'!B12:B1050=C4),('Intarzieri (2)'!D12:D1050)) so that it would add only the red celled ones. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to get result by using CountIF, if there are 3 conditions to b | Excel Worksheet Functions | |||
COUNTIF on result of formula | Excel Discussion (Misc queries) | |||
Using sum(1/countif....) not returning expected result | Excel Worksheet Functions | |||
How to make the Result of a TODAY Function static? | Excel Worksheet Functions | |||
Subtracting a Countif result from a constant | Excel Worksheet Functions |