Aug 01 2019 08:29 AM - edited Aug 01 2019 11:07 AM
I want to count and add the value in cell B:B if cell A:A is red and D:D is today
red | 25 | 8/9/2019 | ||
blue | 27 | |||
red | 65 | 9/9/2019 | ||
total | red | 90 | 8/9/2019 | 25 |
blue | 27 | 8/9/2010 | 0 | |
|
|
|
Aug 01 2019 08:40 AM
SolutionAug 01 2019 08:41 AM
=SUMIFS(B1:B3,A1:A3,"red") should work for you.
Aug 01 2019 08:59 AM
Aug 01 2019 09:03 AM
Aug 05 2019 01:29 AM
Aug 01 2019 08:40 AM
Solution