Zeszyt1.xls

suma jeżeli dwa warunki - exel dwa warunki

Witam, mam zagwostkę, wy napewno sobie świetnie z nią poradzicie: mam trzy kolumny, chciałam stworzyć funkcję, która zliczy mi wartości z kolumny A, które spełniają dwa warunki = w kolumnie b zawiera 877 i w kolumnie c zawiera "r". Pomocy bo już kombinuję jak koń pod górę:)


" Na podstawie poniższej tabeli wykonaj obliczenia: "
" Liczba sprzedanych aut " ,,,
, " 200 " ,,
, " Warszawa " ,, " Łódź " ,,,,,
, " 2000 " , " 2001 " , " 2000 " , " 2001 " ,,,,
" Punto " ,,,,,,,,
" Seicento " ,,,,,,,,
" Wartości sprzedanych aut w poszczególnych kwartałach "
, " 2000 " ,,,, " 2001 " ,,,
" kwartały " , " 1 " , " 2 " , " 3 " , " 4 " , " 1 " , " 2 " , " 3 " , " 4 "
" Punto " ,,,,,,,,
" Seicento " ,,,,,,,,
" Rok " , " Kwartał " , " Produkt " , " Miasto " , " Liczba " , " Cena " , " Wartość " ,,,
" 2000 " , " 1 " , " Seicento " , " Warszawa " , " 4000 " , " 250000 " , " 1000000000 " ,,,
" 2000 " , " 1 " , " Punto " , " Warszawa " , " 3000 " , " 400000 " , " 1200000000 " ,,,
" 2000 " , " 1 " , " Seicento " , " Łódź " , " 45342 " , " 250000 " , " 11335500000 " ,,,
" 2000 " , " 1 " , " Punto " , " Łódź " , " 5634 " , " 400000 " , " 2253600000 " ,,,
" 2000 " , " 2 " , " Seicento " , " Warszawa " , " 6747 " , " 250000 " , " 1686750000 " ,,,
" 2000 " , " 2 " , " Punto " , " Warszawa " , " 7435 " , " 400000 " , " 2974000000 " ,,,
" 2000 " , " 2 " , " Seicento " , " Łódź " , " 3434 " , " 250000 " , " 858500000 " ,,,
" 2000 " , " 2 " , " Punto " , " Łódź " , " 4747 " , " 400000 " , " 1898800000 " ,,,
" 2000 " , " 3 " , " Seicento " , " Warszawa " , " 6433 " , " 454000 " , " 2920582000 " ,,,
" 2000 " , " 3 " , " Punto " , " Warszawa " , " 6774 " , " 670000 " , " 4538580000 " ,,,
" 2000 " , " 3 " , " Seicento " , " Łódź " , " 7575 " , " 454000 " , " 3439050000 " ,,,
" 2000 " , " 3 " , " Punto " , " Łódź " , " 8678 " , " 670000 " , " 5814260000 " ,,,
" 2000 " , " 4 " , " Seicento " , " Warszawa " , " 3557 " , " 454000 " , " 1614878000 " ,,,
" 2000 " , " 4 " , " Punto " , " Warszawa " , " 7878 " , " 670000 " , " 5278260000 " ,,,
" 2000 " , " 4 " , " Seicento " , " Łódź " , " 7474 " , " 454000 " , " 3393196000 " ,,,
" 2000 " , " 4 " , " Punto " , " Łódź " , " 6366 " , " 670000 " , " 4265220000 " ,,,
" 2001 " , " 1 " , " Seicento " , " Warszawa " , " 7855 " , " 470000 " , " 3691850000 " ,,,
" 2001 " , " 1 " , " Punto " , " Warszawa " , " 3536 " , " 690000 " , " 2439840000 " ,,,
" 2001 " , " 1 " , " Seicento " , " Łódź " , " 5677 " , " 470000 " , " 2668190000 " ,,,
" 2001 " , " 1 " , " Punto " , " Łódź " , " 5643 " , " 690000 " , " 3893670000 " ,,,
" 2001 " , " 2 " , " Seicento " , " Warszawa " , " 8576 " , " 470000 " , " 4030720000 " ,,,
" 2001 " , " 2 " , " Punto " , " Warszawa " , " 7859 " , " 690000 " , " 5422710000 " ,,,
" 2001 " , " 2 " , " Seicento " , " Łódź " , " 7858 " , " 470000 " , " 3693260000 " ,,,
" 2001 " , " 2 " , " Punto " , " Łódź " , " 6785 " , " 690000 " , " 4681650000 " ,,,
" 2001 " , " 3 " , " Seicento " , " Warszawa " , " 6868 " , " 470000 " , " 3227960000 " ,,,
" 2001 " , " 3 " , " Punto " , " Warszawa " , " 7876 " , " 690000 " , " 5434440000 " ,,,
" 2001 " , " 3 " , " Seicento " , " Łódź " , " 7859 " , " 690000 " , " 5422710000 " ,,,
" 2001 " , " 3 " , " Punto " , " Łódź " , " 7858 " , " 470000 " , " 3693260000 " ,,,
" 2001 " , " 4 " , " Seicento " , " Warszawa " , " 6785 " , " 690000 " , " 4681650000 " ,,,
" 2001 " , " 4 " , " Punto " , " Warszawa " , " 6868 " , " 470000 " , " 3227960000 " ,,,
" 2001 " , " 4 " , " Seicento " , " Łódź " , " 7876 " , " 690000 " , " 5434440000 " ,,,
" 2001 " , " 4 " , " Punto " , " Łódź " , " 3299 " , " 690000 " , " 2276310000 " ,,,
,,,,,
,,,,,
,


Download file - link to post