Formula Help

[Bazola]

Hi All

I need some help with a formula if you dont mind....

Bascially I have a Sheet called "Detailed NTWK (LAN) HW Status" and within that a column called "Core Switch Model" (Cell F3:F60), next to that there is a "Core Switch Quantity"(G3:G60). Both of these columns have data validation list assigned so they choose the switch model and then select the number of.

So what I need...

I have another sheet, called "Hardware Oder Details" and I want to basically list how many switches have been ordered model wise across all of our sites. Essentially a formula to add Core switch model x Core Switch Quantity and then provide the number.

I hope you can help.

Thanks
Bazola

 

[Marcelo Branco]

Try SUMIF
Take a look at
http://www.contextures.com/xlFunctions01.html#SumIf

M.

 

[Bazola]

Thanks, I've had a look and I am struggling to understand what I need to use. If you could provide some further assistance, it would be appreciated.

 

[Marcelo Branco]

See if this example helps

On sheet Hardware Oder Details put all the models in column A (Model1, Model2, Model3,... ) and use the formula below in column B

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

A​

[/td][td="bgcolor: #DCE6F1"]

B​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Model​

[/td][td]

Result​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

Model1​

[/td][td]

40​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

Model2​

[/td][td]

12​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

Model3​

[/td][td]

32​

[/td][/tr]
[/table]

Formula in B2 copied down
=SUMIF('Detailed NTWK (LAN) HW Status'!$F$3:$F$60,A2,'Detailed NTWK (LAN) HW Status'!$G$3:$G$60)

M.