Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
amandax Profile
 | Femeie
19 ani
Iasi
cauta Barbat
32 - 47 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2241
|
|
Works only for Excel 2007 and newer.
=SUMIFS(G:G;(A:A);"="&L2;(D:D);"="&M2;(J:J);"="&N2)
This works for any excel version:
=SUMPRODUCT(--(A:A=L2);--(D:D=M2);--(J:J=N2);G:G)
or
=SUMPRODUCT(--(A4:A10000=L2);--(D4:D10000=M2);--(J4:J10000=N2);G4:G10000)
In L2 write value needed to be searched in column A
In M2 write value needed to be searched in column D
In N2 write value needed to be searched in column J
_______________________________________
|
|
| pus acum 10 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Simple SUMIF formula:
=SUMIF(B1:B10;"deseu menajer";A1:A10)
unde
B1-B10 e lista de deseuri
si
A1-A10 sunt numerele ce trebuie insumate
|
|
| pus acum 10 ani |
|