Return to Answer

Your formula is syntactically sound therefore the issue is likely with your data. Did you copy and paste and/or change the formatting?

I suspect the problem is something like your times are now formatted as text strings, or your dates are actually dates and times.

Troubleshooting

1. Identify a single row of data that you believe should be added. In other words, it meets the following 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test may have an "aha" moment or at least know where to focus your efforts.

Your formula is syntactically sound therefore the issue is likely with your data. Did you copy and paste and/or change the formatting?

I suspect the problem is something like your times are now formatted as text strings, or your dates are actually dates and times.

Troubleshooting

1. Identify a single row of data that you believe should be added. In other words, it meets the following 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test you may have an "Aha!" moment or at least know where to focus your efforts.

Your formula is syntactically sound therefore the issue is with your data.

1. Identify a single row of data that you believe should be added. In other words, it meets the following 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test you will know where to focus your efforts.

Your formula is syntactically sound therefore the issue is likely with your data. Did you copy and paste and/or change the formatting?

I suspect the problem is something like your times are now formatted as text strings, or your dates are actually dates and times.

Troubleshooting

1. Identify a single row of data that you believe should be added. In other words, it meets the following 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test may have an "aha" moment or at least know where to focus your efforts.

Your formula is syntactically sound therefore the issue is with your data.

1. Identify a single row of data that you believe should be added. In other words it meets the foolowing 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test you will know where to focus your efforts.

Your formula is syntactically sound therefore the issue is with your data.

1. Identify a single row of data that you believe should be added. In other words, it meets the following 3 criteria:
   1. It has time<>0 in Column N
   2. It has "name"="name of person" in Column G
   3. It has date=TODAY() in Column B.
2. Use a formula to test your assumptions for that row in isolation from the rest of the data.
3. For example, assuming you believe Row 5 meets all three criteria, the following formula will determine if your assumption is correct:

   =IF(ISNUMBER('Annual Data'!N5),
       "✓ Time is a Number", "✘ Time isn't a Number!")&
    IF('Annual Data'!G5="name of person",
       " - ✓ Name Matches", " - ✘ Name doesn't Match!")&
    IF('Annual Data'!B5=TODAY(),
       " - ✓ Date Matches", " - ✘ Date isn't Today!")
   

   Based on the results of this test you will know where to focus your efforts.