Afternoon all,
Looking for help writing a formula for a ledger spreadsheet that counts multiple entries for a single date (counts as 1 per date group) but only counts the entry if there is an associated time with the same row. I have gotten the COUTNIF function to work perfectly, but only counting multiple day entries as a single count.
What I have currently:
=SUM(IF(C8:C200<>"",1/COUNTIF(C8:C200, C8:C200), 0))
2021-04-01 13_41_37-Time_Ledger_2021_v2 - Excel.png
In the attached picture, The cells in orange (column C) will count as 1 day in my spreadsheet, but I am looking for only the top one to count as 1 because there is a time value associated with it (column H, in orange).
I have tried variations of:
=SUM(IF((C8:C200<>"")*(H8:H200<>""),1/COUNTIF(C8:C200, C8:C200), 0))
but it returns a decimal value instead of a whole number. Any help would be greatly appreciated!!!
Bookmarks