Really struggling with getting a formula working based on the following criteria:
Multiple spreadsheet tabs, so this tab 1 is where I am writing the formula, which will reference data in a separate tab named 'All Data'. What the cell formula I'm trying to capture is a total count of rows where:
All Data tab, column Z, rows 2 - 360 is greater than or equal to 60, but less than 90
All Data tab, column T, rows 2 - 360 is equal to P or I (there are multiple letters in this row)
All Data tab, column AD, rows 2 - 360, where name is equal to the name in cell A54 of the primary spreadsheet tab I am writing the formula.
Here is what I have, but does not seem to be working:
=SUMPRODUCT(--('All Data'!$Z$2:$Z$360>=60)*('All Data'!$Z$2:$Z$360<90)*('All Data'!$T$2:$T$360="P" or “I”),--('All Data'!$AD$2:$AD$360=A54))
This should give me the total rows that meet this criteria. It's not working. I think the hiccup in this formula is the "P or "I" line.
Recommendations?
TJM
Bookmarks