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:
claudiaa22tm
 | Femeie
19 ani
Timis
cauta Barbat
29 - 43 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
What I needed to do was make a sum of numbers in a range, given multiple conditions:
- between a date interval
- for given material types
Eg:
- between 14.04.2018 and 26.04.2018, but including those 2 dates
- search for 18 types of materials and sum their corresponding quantities
I used:
=SUMIFS(D:D;C:C;M4;A:A;">="&$L$4;A:A;"<="&$L$5)
where:
- D:D is sum range
- C:C is material type range
- M4 is material type
- A:A is date range
- L4 is beginning date of the period
- L5 is end date of the period
Source (didn't know syntax for interval/period):
Modificat de TRaP (acum 6 ani)
|
|
| pus acum 6 ani |
|