Spreadsheet: 169766d1343055056-combine-two-formulas-to-count-countif-and-productsum-excelq-countifs
Sheet: Sheet1

 |  |  |  | Date received | Aspect | TRADE DATE | Column1
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-05-15 00:00:00 |  | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | no | 2012-05-16 00:00:00 |  |  |  |  |  |  | OPTION 1
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-05-17 00:00:00 |  |  |  |  |  |  | OPTION 2
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-05-22 00:00:00 |  |  |  |  |  |  | OPTION 3
 |  |  |  | 2012-07-20 00:00:00 | yes | 2012-05-22 00:00:00 |  |  |  |  |  |  |  |  | I have a short question where I am struggling with for a while:
 |  |  |  | 2012-07-21 00:00:00 | no | 2012-05-22 00:00:00 |  |  |  |  |  |  | [NAME]
 |  |  |  | 2012-07-18 00:00:00 | no | 2012-05-27 00:00:00 |  |  |  |  |  |  |  |  | In cell I3 to M5 are three option to calculate 3 options to count if the seperate values in column G minus I2 are bigger or equal to 30.
 |  |  |  | 2012-07-16 00:00:00 | yes | 2012-05-27 00:00:00 |  | 11 | 9 | 5 | 5 | 5 | What answer needs to be:
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-02 00:00:00 |  |  |  |  |  |  |  |  | But I have to make this number also dependent of two other variables in column E and F
 |  |  |  | 2012-06-20 00:00:00 | no | 2012-06-04 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-06-08 00:00:00 |  |  |  |  |  |  |  |  | So I Have two formulas that I have to combine a countifs and productsum
 |  |  |  | 2012-05-20 00:00:00 | yes | 2012-06-09 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-06-09 00:00:00 |  |  |  |  |  |  |  |  | So in total three things have to be done:
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-06-10 00:00:00 |  |  |  |  |  |  |  |  | Date received has to be bigger then cell I2, and Aspect needs to be yes (column F), and count of these cells if the seperate values in column G minus I2 are bigger or equal to 30.
 |  |  |  | 2012-07-20 00:00:00 | yes | 2012-06-11 00:00:00 |  |  |  |  |  |  |  |  | Hope someone can help me!
 |  |  |  | 2012-07-21 00:00:00 | yes | 2012-06-11 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | no | 2012-06-11 00:00:00 |  |  |  |  |  |  |  |  | Thanks a lot
 |  |  |  | 2012-07-16 00:00:00 | yes | 2012-06-11 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-12 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | yes | 2012-06-12 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-06-13 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | yes | 2012-06-14 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-15 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-06-15 00:00:00
 |  |  |  | 2012-07-20 00:00:00 | no | 2012-06-16 00:00:00
 |  |  |  | 2012-07-21 00:00:00 | yes | 2012-06-16 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | yes | 2012-06-17 00:00:00
 |  |  |  | 2012-07-16 00:00:00 | yes | 2012-06-17 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-17 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | yes | 2012-06-18 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-06-18 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | no | 2012-06-19 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-06-19 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-06-20 00:00:00
 |  |  |  | 2012-07-20 00:00:00 | yes | 2012-06-20 00:00:00
 |  |  |  | 2012-07-21 00:00:00 | yes | 2012-06-20 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | yes | 2012-06-21 00:00:00
 |  |  |  | 2012-07-16 00:00:00 | yes | 2012-06-21 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-06-22 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | yes | 2012-06-22 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | yes | 2012-06-23 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | yes | 2012-06-24 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-25 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-06-25 00:00:00
 |  |  |  | 2012-07-20 00:00:00 | no | 2012-06-25 00:00:00
 |  |  |  | 2012-07-21 00:00:00 | no | 2012-06-26 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | no | 2012-06-26 00:00:00
 |  |  |  | 2012-07-16 00:00:00 | no | 2012-06-27 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-06-27 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | yes | 2012-06-28 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-06-29 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | no | 2012-06-29 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-06-30 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | no | 2012-06-30 00:00:00
 |  |  |  | 2012-07-20 00:00:00 | no | 2012-07-01 00:00:00
 |  |  |  | 2012-07-21 00:00:00 | no | 2012-07-02 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | yes | 2012-07-03 00:00:00
 |  |  |  | 2012-07-16 00:00:00 | yes | 2012-07-04 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | yes | 2012-07-05 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | no | 2012-07-06 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | no | 2012-07-06 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | no | 2012-07-06 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-07-07 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-07-08 00:00:00
 |  |  |  | 2012-07-20 00:00:00 | no | 2012-07-09 00:00:00
 |  |  |  | 2012-07-21 00:00:00 | no | 2012-07-09 00:00:00
 |  |  |  | 2012-07-18 00:00:00 | no | 2012-07-10 00:00:00
 |  |  |  | 2012-07-16 00:00:00 | no | 2012-07-10 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-07-10 00:00:00
 |  |  |  | 2012-06-20 00:00:00 | no | 2012-07-11 00:00:00
 |  |  |  | 2012-05-25 00:00:00 | yes | 2012-07-12 00:00:00
 |  |  |  | 2012-05-20 00:00:00 | yes | 2012-07-13 00:00:00
 |  |  |  | 2012-07-17 00:00:00 | no | 2012-07-15 00:00:00
 |  |  |  | 2012-05-23 00:00:00 | yes | 2012-07-17 00:00:00