Using SumProduct on multiple lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top