Hi everyone,
I am looking to compile a spread sheet that breaks down certain data.
I am using a COUNTIFS formula for it, it works for 'A' but when I adjust it for 'B' is doesn't work. Highlighted in yellow on my sheet. I can't figure out why, it's the same formula just the criteria is slightly altered.
Any help would be appreciated.
Thanks
In B2, copied down:
=IFERROR(TEXT(1/(1/C2),"ddd"),B1)
Last edited by Glenn Kennedy; 05-09-2017 at 08:34 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Change the formula in as your formula is giving wrong answer
Try
N16Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Change:
=COUNTIFS($B$3:$B$400,"Mon",$C$3:$C$400,O15,$E$3:$E$400,">=529")
To:
=COUNTIFS($B$3:$B$400,"Mon",$C$4:$C$401,O15,$E$4:$E$401,">=529")
The results are correct.
Your formula for column O ("B") is saying
where column B equals Tue AND column C is "B"
There is NO row that matches this as your "days" are all on a row that has "A" in column C.
Copy the days downwards in column B in each table and it should work.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Exactly, Sp-K. Thats the function of the formula at post 2...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks