i know you cannot have multiple criteria on countif but could someone explain how to get around it.
i currently use a countif =COUNTIF(C4:S4,"<="&$U$1) which works fine. This formula check rows c4:s4 for a time that is less or equal to the value in U1 and counts them. the problem i have now is that this formula worked on start times, i now have been asked to put the finish time next to each cell (But not count that value) so i need to amend my formula that it would do the same calculation but only if the word start is in the row C3:S3.
Bookmarks