excel hades (cross reference maybe intersection)

Hello, I am having to figure out a particularly painful excel formula. What i need is a formula that will count the number of times an issue label in text shows up, but it has to match a certain time.

we can get the excel sheet to round the time to the nearest thirty minutes, so if a call comes in at 3:12pm it rounds it to 3pm. We label the calls that come in with a issue description also like "dvr issue." So i need a formula that will allow me to count the number of instances where if it says 3pm AND dvr issue it will only count it and give me a total in a specified cell. Is that possible?

=SUMPRODUCT( (A1:A10 = "15:00"+0) * (B1:B10 = "dvr issue"))

I just tried it and it returns a value of zero. Doesn't look like it counted it. Thanks for trying though. any other ideas?

The formula is fine.

Did you adjust the ranges appropriately? Do the time cells really contain Excel times? Is there a time exactly equal to 15:00? Is the text you're looking for exactly "dvr issue"?

If the answer to all of those is yes, post a workbook.

I believe so I have this
=SUMPRODUCT((B:B="DVRISSUE")*(C:C=D2))

so in theory this should look in column b for dvr issue and then check column c for the value of d2 in this case representing 7am right?

Right .

weird im getting a total count of 253 and there are 272 issues to list out?

Zero to 273, that's progress.

Post a workbook.

You don't need 3.5MB to illustrate the problem. How about 100 rows by two columns?