SUMPRODUCT help needed
I believe I'll need to use the SUMPRODUCT function, but can't even begin to guess how.
On Sheet1, I have two columns: Status and Server. The server numbers are 'p066', 'p123', 'p223', and so on. The status is either two values: "Not Restored" or "Restored".
On Sheet2, I have 3 columns: Server#, # Restored, and # Not Restored. What I'd like to do is count all the rows that say "Restored" in column B from Sheet1 but the C column from Sheet1 MUST have the value in the "A" column from Sheet2.
I know that makes no sense whatsoever, so I've uploaded my spreadsheet in hopes that someone can take a glance at it and help me out.
Any help would be greatly appreciated.
|