I’ve been trying to find a way to do this but is not working as I need, if it’s even possible. I have a table like this:
| Column A | Column B | Column C |
|---|---|---|
| 1/1/2000 | qwe | 2 |
| 2/1/2000 | asd | 3 |
| 3/1/2000 | zxc | 4 |
I need to add up the numbers on column C, if the day on column A is less or equal to a number and I need to also only add up numbers if the word on column B match a keyword.
In this example the day could be less than 2, and the keyword “e”.
I should get a result of 2, but it doesn’t work.
I tried with =SUMPRODUCT((C1:C3)*(DAY(A1:A3)<=2)*(B1:B3="=*e*")) and =IF(DAY(A1:A3)<=2,SUMIF(B1:B3,"=*e*",C1:C3))
Thanks in advance.
New contributor
Juan Zepeda is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1