Results 1 to 3 of 3
Thread: Ôîðìóëà íà Åêñåë
Hybrid View
-
10th June 2008 14:19 #1Registered User
Join Date: Dec:2005
Location: Bulgaria
Posts: 4
Ôîðìóëà íà Åêñåë
Çäðàâåéòå,
Èìàì åäèí sheet â Excel êîéòî â åäíà êîëîíêà èìàì åãí-òà íà êëèåíòè à â ñëåäâàøàòà êîëîíêà ñóìàòà íà ïîêóïêàòà êîÿòî ñà íàïðàâèëè, êàòî äàäåí êëèåíò ìîæå äà ñå ïîâòîðè íÿêîëêî ïúòè ñ ðàçëè÷íè ñóìè. Âúçìîæíî ëè å â 2-ðè sheet ÷ðåç ôîðìóëà äà ñúáåðà îáùàòà ñóìà íà äàäåí êëèåíò? Çíàì çà ôîðìóëàòà vlookup ÷å òúðñè è èçêàðâà èíôîðìàöèÿ ïî äàäåí ïàðàìåòúð íî ÿâíî ñ íåÿ íåìîãà äà ñúáåðà ñóìàòà. Áëàãîäàðÿ íà âñè÷êè îòçîâàëè ñè.
-
10th June 2008 15:04 #2
Ðàçãëåäàëè SUMIF ?
I mourn thee by dusk | I mourn thee by dawn
Crave for thy gloss | to seek the silent glades beyond
-
10th June 2008 15:16 #3Registered User
Join Date: Dec:2005
Location: Bulgaria
Posts: 4
äà ñòàíà áëàãîäàðÿ òè ìíîãî




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè