Total from SUMPRODUCT not correct

[JoeMonteCarlo]

Named Ranges are: Row1_, Row3_, Row3_, Row7_, Row9, Row11, Rack, Model


Row1_ E4 F4 G4 H4 I4
Row3_ E10 F10 G10 H10 I10
Row5_ E13 Z13 G13 H13 I13
Row7_ E19 Z19 G19 H19 I19
Row9_ E22 Z22 G22 H22 I22


Unit Rack Model
24 F10 IBM
36 G4 Cisco
1 H19 Sun
15 E22 Sun
15 I22 HP
8 E4 IBM
34 G4 Cisco
12 Z19 IBM


IBM Dell Sun HP Cisco
1 0 0 0 1


Same formula for each of the above Models. Problem is that I'm only getting one of the "Rack"-G4 "Model"-Cisco entries counted, not both…
=SUMPRODUCT((Rack=Row1_) * (Model="Cisco"))

Thanks in advance!

 

[scottylad2]

I looks from your data that there is only one Cisco in ROW 1, should you be counting the column perhaps? Theres 2 there

 

[JoeMonteCarlo]

The top table is how the racks are placed in rows (using spreadsheet type of grid pattern)

The middle table shows where the systems are placed.. (1st) Cisco in Rack G4, unit 36..... and the (2nd) Cisco also in rack G4, unit 34.

The bottom table should have resulted with a 2, showing both Cisco's placed at location G4.

 

[rossbritton26]

JoeMonteCarlo,

Just tested what you were trying to do, seems to work fine, got a result of 2....
Might be worth checking spelling etc...??

 

[JoeMonteCarlo]

Oh my... you're correct! I typed it in correctly in the post, but had it wrong in the spreadsheet.

Thank you both for taking the time to help me with this.

-Joe