View Single Post
  #1   Report Post  
Ramiro Espinoza
 
Posts: n/a
Default Countif and Conditional Formatting

I'm trying to use a count if function to count how many rows are met by a
conditional format placed on the worksheet so it only counts those items.
I have the formula set as such:
=COUNTIF($E1,=IF(($E1-WEEKDAY($E1,2))+1$L1,True,False)
so basically (as I interpret this. This is my first foray in this type of
formula.)
Countif from a range of Column E If Conditional Formatting. Is there
something wrong with syntax or something. It keeps coming out zero when I
know the conditional programming is valid. Any help is appreciated. Thanks.
Ramiro