Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Year | 2017 | ||||
2 | ||||||
3 | Date | DR | SI | Amount | ||
4 | 01/28/2016 | 123 | 20.00 | |||
5 | 01/23/2016 | 456 | 50.00 | |||
6 | 02/28/2017 | 333 | 30.00 | |||
7 | 03/17/2017 | 789 | 50.00 | |||
8 | 04/15/2017 | 444 | 10.00 | |||
9 | ||||||
10 | ANSWER | 40.00 | ||||
Sheet1 |
hi guys is there a formula for there i want to know the sum of column D with this fallowing criteria
1. year of the given date on column A has the same year on cell B1
2. column C has a value greater than zero
thanks