Mam v subore Harok1 a Harok2
v Harok1 su v stlpci A umiestnene typy zariadeni (mobil, tablet, notebook), v stlpci B vyrobcovia (Asus, Nokia) a v stlpci C pocet kusov tych vyrobkov, ktore su prave v servise.
v Harok2 su v stlpci A uvedene typy (mobil, tablet, notebook) a potrebujem ich jednotlivo scitat, aby som dostal, kolko mobilov je v servise celkovo, kolko tabletov.
Viem sa odkazat na prvok z ineho harku cez jeho nazov a vykricnik, viem potom uz dalej riesit operacie, ktore su tam dane, preto ich ani opisovat uz nebudem, len si neviem dat rady, aby som dostal do Harok2 iba sucet riadkov, kde v stlpci A maju napisane mobil, napriklad.
vie niekto dat tip?
_________________
PC: MSI B450 GAMING PLUS / AMD Ryzen 5 2600 / SilentiumPC Fera 3 HE1224 / ADATA XPG Spectrix D40 DDR4 2x8GB / Gainward GeForce GTX 1060 Phoenix 6GB / Adata XPG Gammix S11 M.2 SSD 480GB NVMe / Seagate BarraCuda HDD 2TB / WD Green 4TB / WD My Book Essential 3.0 2000GB / WD Elements 2000GB / ASUS BW-16D1HT / Creative Sound Blaster Audigy RX / Corsair CX450M / SilentiumPC Regnum RG4T / Dell P2719H / Microsoft Natural Ergonomic Keyboard 4000 / Logitech G102 Prodigy Gaming Mouse / Microlab SOLO9C / Microlab B77 / SONY WH-1000XM4 / Koss Porta Pro / Microsoft Windows 10 64-bit FPP
PC (history): ASUS M4A785TD-V EVO / Athlon II X4 640 / Hynix 8GB (2x4GB) DDR3 1600 MHz / Sapphire HD7750 1GB Ultimate Silent Series / AMD Radeon R3 120GB / Seagate 7200.12 500GB / Samsung SH-S223L / Creative Sound Blaster X-Fi XtremeMusic / Axago PCEU-43R USB3.0 / TP-LINK TG-3269 / Corsair VS450 / 24" BenQ G2420HDBL / Gigabyte GT-U8300
NTB: Huawei MateBook D15 NTB2: Alcatel PLUS 10 LTE NTB3: MSI M670X-091SK / Transcend 2x1GB DDR2 667MHz
Phone: Samsung Galaxy S9 Phone2: Samsung Galaxy S20+
Turntable: Tesla NC 470 / Ortofon OM 5E | 
