Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

First of all, the if function for conditional formatting while working is not
necessary, just extra typing

=$E1-WEEKDAY($E1,2)+1$L1

will do, if you want to count how many dates in E where the previous Monday
is later than the date in L1 you can use

=SUMPRODUCT(--($E1:$E10-WEEKDAY($E1:$E10,2)+1$L1))


Regards,

Peo Sjoblom

"Ramiro Espinoza" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
countif reno Excel Worksheet Functions 5 November 5th 04 01:20 PM


All times are GMT +1. The time now is 11:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"