Forum Discussion

Kaloyan Stoyanov's avatar
Kaloyan Stoyanov
Copper Contributor
Mar 14, 2018
Solved

Formula to count cell with conditional formatting

Hi,   I have a data table that's mainly with dates. The B column - "Deadline", is with referential dates, and in subsequent columns are the dates to each individual. I'm using conditional forma...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 14, 2018

    Hi Kaloyan,

     

    I'd suggest

    =SUMPRODUCT( ISNUMBER([Alexander Phillips])*([Alexander Phillips]>Table1[[Deadline]:[Deadline]]))

    With COUNTIFS every second parameter shall be criteria only, without repeating the range

     

    Please see attached

SergeiBaklan's avatar
SergeiBaklan
MVP
Mar 14, 2018

Hi Kaloyan,

 

I'd suggest

=SUMPRODUCT( ISNUMBER([Alexander Phillips])*([Alexander Phillips]>Table1[[Deadline]:[Deadline]]))

With COUNTIFS every second parameter shall be criteria only, without repeating the range

 

Please see attached

Resources