Forum Discussion
Solved
Problems with Excel 365 sheet, COUNTIFS formula...see attached sheet with narrative about my issue
I would need to attach a sample sheet in order to adequately explain the issue at hand. I don't see a paperclip here. Let's start out by giving me instructions on how to attach an Excel sheet please....
If D7 contains a formula such as =C7 and is formatted as dddd, column D still contains dates, not text strings.
If so, try changing the formula to =TEXT(C7,"dddd") and fill down, to see if that makes a difference.
For clarity, D7 contains the formula, =IF(C7=""," ",WEEKDAY(C7)) thus pulling the day referenced in the manually input date held in C7. And, D7 is formatted as "dddd" as is D3. Funny thing though is that the COUNTIFS formula I created, when referencing the value in D3 works right but when referencing D7 does not. Both cells contain the same underlying format "dddd"...weird!
And, the reason I add the IF(C7=""," ", portion is for visual clean up when usually an error would be reflected. Just how I prefer to create my formulas.
Sorry, forgot to mention that I did try your fix in a separate cell written as =TEXT(C11,"dddd"), the change in cell reference made to choose a cell that had some results (3). I ended up with a 0 as was the case in prior attempts. Any other ideas?
Either way I really appreciate your input!
Douglas
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I would not only be happy to but prefer to.
I think I will need to share this with you which means I think I would need your email address. Maybe we would need to be outside this chat to convey such information?
See the attached version.
Hans...you are the man!!!
I really did try the formula you sent over last, seriously. Regardless, yours worked beautifully!
Douglas