![]() How do I do this?Īnswer: To use a cell reference in the criteria, you could do the following: =COUNTIF(C4:C19,">="&A1) ![]() ![]() Question: I am using the COUNTIF function and I would like to make the criteria equal to a cell.įor example: =COUNTIF(C4:C19,">=2/26/04") Here's an example of what I'd like to be able to do: =COUNTIF(A2,A5,F6,G9,">0")Īnswer: Unfortunately, the COUNTIF function does not support multiple ranges. Question: I'm trying to use COUNTIF on a selection of cells (not necessarily one solid range), and the syntax of the function does not allow that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |