I am working on a reporting spread and need some help making a total.

Example of sheet:
Station ID Keyboard Mouse
----------- ----------- -------
S1 Missing
S2 Damaged
S3 Missing
S4

I currently have a SUMPRODUCT funtion where it will check the cells that if
it has no typing in Keyboard and Mouse fields then it will add a 1 to a
different area of the sheet where I will have a running total. (that is where
I have the SUMPRODUCT function).

How can I make it so I can use one cell and have the formula check the
spaces in S1, S2, S3, S4

Code I have right now:
=SUMPRODUCT(--(b3=""),--(c3=""))

Something like it will have an array where it will run the same function but
make it check b4 and c4 then b5 and c5

If I understand the question, try
=SUMPRODUCT(--(b3:b5=""),--(c3:c5=""))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chart_Maker_Wonderer" wrote
in message ...
I am working on a reporting spread and need some help making a total.

Example of sheet:
Station ID Keyboard Mouse
----------- ----------- -------
S1 Missing
S2 Damaged
S3 Missing
S4

I currently have a SUMPRODUCT funtion where it will check the cells that
if
it has no typing in Keyboard and Mouse fields then it will add a 1 to a
different area of the sheet where I will have a running total. (that is
where
I have the SUMPRODUCT function).

How can I make it so I can use one cell and have the formula check the
spaces in S1, S2, S3, S4

Code I have right now:
=SUMPRODUCT(--(b3=""),--(c3=""))

Something like it will have an array where it will run the same function
but
make it check b4 and c4 then b5 and c5

hi,
here my suggestion is use the excel function to make it as output what you
want
=IF(D6="",1,"") [ D6 is nothing but the cell value in the keyboard/mouse ]

Regards,
Pugal

"Chart_Maker_Wonderer" wrote:

I am working on a reporting spread and need some help making a total.

Example of sheet:
Station ID Keyboard Mouse
----------- ----------- -------
S1 Missing
S2 Damaged
S3 Missing
S4

I currently have a SUMPRODUCT funtion where it will check the cells that if
it has no typing in Keyboard and Mouse fields then it will add a 1 to a
different area of the sheet where I will have a running total. (that is where
I have the SUMPRODUCT function).

How can I make it so I can use one cell and have the formula check the
spaces in S1, S2, S3, S4

Code I have right now:
=SUMPRODUCT(--(b3=""),--(c3=""))

Something like it will have an array where it will run the same function but
make it check b4 and c4 then b5 and c5