Too tough for me....

[soltek]

I have 2 columns. One column, S , formulates networkdays between tw
dates. Column two, U , formulates a "D" or "S" depending a list o
codes it matches. AND there is conditional formatting on bot
columns. S column is formatted to show overdue dates. Column U i
formatted to highlight the S cells. How can I count the highlighte
cells in column S? AM i making this too hard on myself

 

[Bob Phillips]

Easiest way is to create a formula that counts the same condition that the
CF uses.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[soltek]

Could anybody give me an example of how to do this, count the number o
overdue items in a column? I am using conditional formatting to sho
overdue, but cant seem to replicate the CF code in a norma
condition.... I have a column "U" to show either D or S for deskto
or server. the other column shows the number of days it took to build
If a server takes longer than 5 days, it is highlighted andI would lik
to count how many times this occurs. And also count how many times thi
occurs for a desktop if over 2 days.?

 

[soltek]

sorry here is my conditional formatting to highlight overdue dates.

=(U7:U1000="D")*(S7:S1000>2), and
=(U7:U1000="S")*(S7:S1000>5)

These are what i cant seem to use in a formula..

 

[Bob Phillips]

=SUMPRODUCT((U7:U1000="D")*(S7:S1000>2))

=SUMPRODUCT((U7:U1000="S")*(S7:S1000>5))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)