Update: Do I use countif or countifs? I have a sheet with numerous tickets (rows) in it, and each row has a part number in column E some are the same most are different. On a seperate tab I need to populate a table with only one of each part and then give a count as to how many rows have that part number in column E. But i only want a count if there is an end date (of any value/date) in column H.
Original Post: I need a formula that will count all rows that have a specific value in them and also a end date. The end date specifies if the ticket is closed. So basically I am looking for a formula that will count the number of tickets with (generic part number) in column 4 of all tickets and that has a end date (of any value) in column 8.
Please help
Bookmarks