This is what Sheet1 of my Excel Workbook looks like:

   A         B         C     D     E	     F
1  POSITION  HIRING                BENEFITS  WAGE
2  Cashier   Open                  Yes       100
3  Cashier   Open                  No        1000
4  Cashier   Closed                Yes       100
5  Cashier   Closed                No        1000
6  Manager   Open                  Yes       200
7  Manager   Open                  No        2000
8  Manager   Open                  Yes       200
9  Manager   Closed                No        2000


This is what Sheet2 of my Excel WOrkbook looks like:

   A         B                             C
1  POSITION  HIRING OPEN AND BENEFITS YES  TOTAL WAGE
2  Cashier   1                             100
3  Manager   2                             400


What is the formula necessary to calculate cells C2 and C3 on Sheet2?
I do not want to have to rearrange my rows or columns or alter my
sheets in any way, other than entering formulas in cells C2 and C3 of
Sheet2.


Hint:
Cell B2 on Sheet2 is calculated by putting
=SUM(IF(Sheet1!A2:A9=a2,1,0)*IF(Sheet1!B2:B9="Open",1,0)*IF(Sheet1!E2:E9="Yes",1,0))
then INSTEAD of pressing enter press CTRL+SHIFT+ENTER.
Cell B3 on Sheet2 is calculated by putting
=SUM(IF(Sheet1!A2:A9=a3,1,0)*IF(Sheet1!B2:B9="Open",1,0)*IF(Sheet1!E2:E9="Yes",1,0))
and again, INSTEAD of pressing enter press CTRL+SHIFT+ENTER.
If you do it correct and press ctrl+shift+enter, you will see
{=SUM(IF(Sheet1!A2:A9=a3,1,0)*IF(Sheet1!B2:B9="Open",1,0)*IF(Sheet1!E2:E9="Yes",1,0))}
in the formula bar. If you do it wrong, then it will show the wrong value.

[Many thanks to furrycushion-ga to coming up with the solution to the
initial puzzle at http://answers.google.com/answers/threadview?id=385307]