Sum up different cells on different rows to get a total count.

[Tacomans]

I would like the TOTAL SOH column to reflect the totals for both warehouse and store count, but I cannot figure out the formula to get it.
The way the sheets are loaded onto the system means thay cannot be the same so a simple sum across the rows cant be done.
Is there a way of formula to do it ? If there were only a few rows I could do it manually , but the stock is in excess of a thousand lines.

Thanks heaps for looking .

[Punnam]

Hi,

Update the sheet with u required values manually to know the logic .
What is the criteria to sum ?
Punnma

[Tacomans]

Hi Punnam, I have uploaded the new sheet, with explanations, Thanks again.Sorry for the stuff up.

[Punnam]

Hi,
find the attached .

Punnam

[FDibbins]

Try these on sheet1...
C6=VLOOKUP($B6,Sheet2!$B$7:$E$16,MATCH(Sheet1!C$5,Sheet2!$B$6:$E$6,0),0)
copied down and across
I6=VLOOKUP($H6,Sheet3!$B$6:$E$15,MATCH(Sheet1!I$5,Sheet3!$B$5:$E$5,0),0)
copied down and across

N6=VLOOKUP($M6,Sheet2!$B$7:$E$16,4,0)+VLOOKUP($M6,Sheet3!$B$6:$E$15,4,0)
Copied down

[Tacomans]

Hi FDibbins, Thanks for your help it works a treat.

[Tacomans]

Thankyou to all !

[FDibbins]

Happy to help and thanks for the feedback