I can't seem to figure out what the syntax should be to get this to work. I have a countifs function that looks for tickets that occur the day after the date in C3 before 6:00 AM. The formula I am using is:
COUNTIFS(Sheet1!$D:$D, "=1+"$C$3, Sheet1!$E:$E, "<6:00 AM", Sheet1!$H:$H, 9, Sheet1!$K:$K, "Folio")
What syntax do I need to get this to work?
Try
=COUNTIFS(Sheet1!D1:D10000,C3+1,Sheet1!E1:E100000,"<"&TIMEVALUE("06:00"),Sheet1!H1:H100000,9,Sheet1!K1:K100000,"Folio")
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.
Yes, thank you! So, if you are adding to a cell reference, do you not need quotes and ampersand?
Cell references shouldn't need quotes (unless they are part of an INDIRECT() formula).
=A1+1 would add 1 to the value in cell A1
=B13*4 would muliply the cell value in b13 by 4
& is used to concatenate items together
="Today is "&TEXT(TODAY(),"ddd")
=A1&B1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks