Spreadsheet: 881526d1729605375-multiple-ifs-count-sum-formula-together-excel-forum
Sheet: Sheet1

MAIN REPORT |  |  |  |  |  |  |  | SOURCE 1 |  |  |  | SOURCE 2
PRODUCT NAME | WHAT I NEED TO GET FROM THE SOURCES | DATE |  |  |  |  |  | Date | PRODUCT NAME | Nr. clauze NB |  | 2024-09-26 00:00:00
 |  | 2024-10-09 00:00:00 | 2024-10-10 00:00:00 | 2024-10-11 00:00:00 |  |  |  | 2024-10-04 00:00:00 | Prudent 30 | 2 |  | 2024-09-26 00:00:00
Life (Regal,Acad,GenT,Smart) | if we can find the curent date (columns C,D,E) in the "Source 1" table + if we can find "Life (Regal,Acad,GenT,Smart)" (column A) ----- please calculate the SUM of the numbers we cand find in K column for these specific rows | formula here | formula here | formula here |  |  |  | 2024-10-04 00:00:00 | PCA | 0 |  | 2024-09-26 00:00:00
PBA Clauze NB (NU se aduna cl.de pe Prudent) | if we can find the curent date (columns C,D,E) in the "Source 1" table, please calculate the SUM of the numbers we cand find in K column for these specific rows -------- but EXCLUDE "Prudent 30" and "ASNN" products | formula here | formula here | formula here |  |  |  | 2024-10-04 00:00:00 | PCA | 0 |  | 2024-09-26 00:00:00
[NAME] | if we can find the curent date (columns C,D,E) in the "Source 2" table, pls count the number of rows with the same date | formula here | formula here | formula here |  |  |  | 2024-10-04 00:00:00 | PCA | 0 |  | 2024-09-26 00:00:00
 |  |  |  |  |  |  |  | 2024-10-04 00:00:00 | PCA | 0 |  | 2024-09-26 00:00:00
 |  |  |  |  |  |  |  | 2024-10-07 00:00:00 | ASNN | 0 |  | 2024-09-26 00:00:00
 |  |  |  |  |  |  |  | 2024-10-08 13:55:16 | ASNN | 0 |  | 2024-09-27 00:00:00
if all the conditions are not met, please leave blank |  |  |  |  |  |  |  | 2024-10-08 00:00:00 | Prudent 30 | 2 |  | 2024-09-27 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | Prudent 30 | 2 |  | 2024-09-27 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | ASNN | 0 |  | 2024-09-27 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | PCA | 0 |  | 2024-09-27 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | ASNN | 0 |  | 2024-09-27 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | ASNN | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | ASNN | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | PCA | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | PCA | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | PCA | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-09 00:00:00 | Life (Regal,Acad,GenT,Smart) | 3 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-10 00:00:00 | ASNN | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-10 00:00:00 | ASNN | 0 |  | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | GRUP Life |  |  | 2024-10-02 00:00:00
 |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | PCA | 0 |  | 2024-10-04 00:00:00
 |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-04 00:00:00
 |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-04 00:00:00
 |  |  |  |  |  |  |  | 2024-10-11 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-04 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | ASNN | 0 |  | 2024-10-07 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-07 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | Prudent 30 | 2 |  | 2024-10-07 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | Prudent 30 | 3 |  | 2024-10-08 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | Prudent 30 | 2 |  | 2024-10-08 00:00:00
 |  |  |  |  |  |  |  | 2024-10-14 00:00:00 | PCA | 0 |  | 2024-10-09 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | ASNN | 0 |  | 2024-10-09 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | ASNN | 0 |  | 2024-10-09 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | Prudent 30 | 4 |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | Prudent 30 | 3 |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | Prudent 30 | 3 |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-15 00:00:00 | Prudent 30 | 2 |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | PCA | 2 |  | 2024-10-10 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | PCA | 2 |  | 2024-10-11 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | PCA | 0 |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | Prudent 30 | 3 |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-14 00:00:00
 |  |  |  |  |  |  |  | 2024-10-16 00:00:00 | Life (Regal,Acad,GenT,Smart) | 2 |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  | 2024-10-17 00:00:00 | Prudent 30 | 2 |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  | 2024-10-17 00:00:00 | PCA | 0 |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  | 2024-10-17 00:00:00 | PCA | 0 |  | 2024-10-15 00:00:00
 |  |  |  |  |  |  |  | 2024-10-17 00:00:00 | PCA | 0 |  | 2024-10-16 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | PCA | 0 |  | 2024-10-16 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | PCA | 0 |  | 2024-10-16 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | PCA | 0 |  | 2024-10-17 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | Prudent 30 | 2 |  | 2024-10-17 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | PCA | 0 |  | 2024-10-17 00:00:00
 |  |  |  |  |  |  |  | 2024-10-18 00:00:00 | PCA | 0 |  | 2024-10-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-10-21 00:00:00