Sum of workstations

  • Thread starter Thread starter hlbrax1
  • Start date Start date
H

hlbrax1

I have a spreadsheet counting workstations with NT and
XP. The columns are as follows:

NT XP Workstation
X 123456ma1234567
X 123456wa1234567
X 123456wa1234567
X 123456ma1234567

I want to count the number of workstaions with XP
and "123456ma1234567" or 123456wa1234567 , number of
workstations with NT and "123456ma1234567" or
123456wa1234567

I've tried using the sumproduct functions but it will
only count one workstation
 
Supposing that A1:C5 houses your sample including labels "NT", "XP", and
"Workstation"...

=SUMPRODUCT(--(INDEX($A$2:$B$5,MATCH("NT",$A$1:$B$1,0))="X"),--($C$2:$C$5<>"
"))

which would count NT workstations. Replace NT with XP for XP workstations.
 
Back
Top