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

	A​	B​
1​	Model​	Result​
2​	Model1​	40​
3​	Model2​	12​
4​	Model3​	32​

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.