RE: Count if

[Bazola]

RE: Count if

Hi All

I need some help if you dont mind,

I have a sheet called "Detailed NTWK (LAN) HW Status, and on there is two columns: -

F3:F60 - Core Switch Model - This is a drop down box for selection
G3:G60 -Core Switch Quantity - This is a drop down box for selection
H3-H60 - Access Switch Model - This is a drop down box for selection
I3-I60 - Access Switch Quantity - This is a drop down box for selection

I then have another sheet called "Hardware Order details" and on there I want it to do a count of particular switch model, so for example: -

F3 on sheet "Detailed NTWRK (LAN) HW Status" on cell F3 Core Switch Model contains model Cisco 2960XR and cell G3 contains the number of them. I want to display a count of each model on the Hardware Order Details Tab but I am struggling to make it work. There is also the same model listed under Access switches so I want to combine the numbers - total numbers of Cisco 2960XR in column H3:H60 & I3-I60.

I hope you can help.

Thanks

 

[Yongle]

Re: Count if

It sounds like you need SumIF rather than CountIf. So try this basic formula and adapt it to your needs:

=SUMIF(F3:F60,"Cisco 2960XR",G3:G60)+SUMIF(H3:H60,"Cisco 2960XR",I3:I60)

Reference to a different worksheet is required before the range
Replace "Cisco 2960XR" with the cell reference
etc

 

[Bazola]

Re: Count if

Thank you, I ended up doing a SUMIFS