SUMPRODUCT help needed

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


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 spread***
in hopes that someone can take a glance at it and help me out.

Any help would be greatly appreciated.


+-------------------------------------------------------------------+
|Filename: ezboard.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3483 |
+-------------------------------------------------------------------+

--
bradgrafelman
------------------------------------------------------------------------
bradgrafelman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24228
View this thread: http://www.excelforum.com/showthread.php?threadid=378442

.

Quantcast