Too tough for me....

  • Thread starter Thread starter soltek
  • Start date Start date
S

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
 
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)
 
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.?
 
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..
 
=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)
 
Back
Top