Adding Conditional look up to SUMPRODUCT and COUNTIF

[Patty McJorst]

Hi All!

I'm working with a spreadsheet that pulls data from another page. I have all my formulas figured out for when I only have one user, but I struggle when I want to create it for the master list (breaking it down by person's name). Let me give an example:

Worker Name	Number of Cases	Cases Worked yesterday	Total $ Spent	Priority 1 Designation
Doe	3	3	26000.00	0
Obama	1	1	9000.00	1

The numbers are automatically populated with either a COUNTIF function or a SUMPRODUCT function, depending on the criteria. What I need to do now is get them to calculate based on the "Worker Name" from the main sheet.

Any ideas?

Edit: I want to clarify. Some of them are looking things up appropriately while others don't. Here's my current formulas that need help:
Priority: =COUNTIF('[spreadsheet name]'!I2:I200,"1")
Cases worked previous day: =SUMPRODUCT(('[spreadsheet name]'!$AD$1:$FS$1=TODAY()-1)*('[spreadsheet name]t'!$AD$1:$FS$2301="√"))