Forum Discussion
Tony2021
May 01, 2021Steel Contributor
Summing - Vlookup and Dates
Hello Experts, I need a formula that will sum values based on a the expected monthly dollar increases or decreases contained in a table for a matrix of companies. I think it would be some s...
- May 01, 2021
You need to try this:
=$G2 + Sumifs($C$2:$C$4, $B$2:$B$4, "<="&H$1, $A$2:$A$4, $F2)
I have attached the file with the solution. Hope it addresses your need.