SUMProduct help counting # of records between 2 dates with additional condition

[krichmond0306]

I guess I am not using this right and desperately need some guidance. I have multiple worksheets which may be where my problem is without giving away too much info here is my formula

=SUMPRODUCT(('Back Log Input'!A906:A1157<='Back Log Data'!R3)*('Back Log Input'!A906:A1157>='Back Log Data'!R2)*('Back Log Input'!C906:C1157="601"))

I was trying to count the # of records between dates (Back Log Data'!R3 and Back Log Data'!R2) from the table that holds my records (Back Log Input'!A906:A1157 that reference the term "601" from that same worksheet.

Am I an idiot?

[Richard Buttrey]

..... without giving away too much info here is my formula.....Am I an idiot?

Well only in so far as you admit you're not giving away too much.

What's the error you're getting?
Please upload your workbook, anonymised if necessary so that we do have 'too much'.

[krichmond0306]

I can not upload the workbook as I work for a Defense Contractor, hence my trying to walk the line of providing as much info as possible without providing too much.

[ConneXionLost]

Is "601" supposed to be a number or text?

[krichmond0306]

it is a number

[Richard Buttrey]

That's why I said anonymise it.

We don't need to know the client's chief representative, Mahmoud Ahmadinejad from Ali Khamenei Inc. based at Khatam al-Anbiya air defence base is ordering a centrifuge type US1234 (pat. pend.)

In true Dragnet style, just change the names to protect the innocent.

[krichmond0306]

That's why I said anonymise it.

We don't need to know the client's chief representative, Mahmoud Ahmadinejad from Ali Khamenei Inc. based at Khatam al-Anbiya air defence base is ordering a centrifuge type US1234 (pat. pend.)

In true Dragnet style, just change the names to protect the innocent.

I understand that, I will try to post it but it will take awhile to anonymize it

[Richard Buttrey]

I understand that, I will try to post it but it will take awhile to anonymize it

...I should also have added delete most of the rows. We only need a representative sample so maybe a few dozen will suffice.

[ConneXionLost]

If "601" is supposed to be a number, then it should not be contained in quotes. Try changing this portion of the formula from:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.