• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countifs and formulas

B

bfraser

Member
Col S uses forumla =IF(Q4="","Overdue",IF(Q4>TODAY(),"Not Due","Overdue"))


On a seperate worksheet, I have formula =COUNTIFS(Sheet2!A4:A1746,"BR",Sheet2!S4:S1746,"Not Due") gives a zero.


Cell A4 = "BR"

Cell S4 = "Not Due"


How does COUNTIF or ...IFS work when a cell is populated by a formula?
 
You must log in or register to reply here.
Back
Top