Forum Discussion
Solved
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...
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.
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.
- Viz, wow that is amazing! Thank you so much for the quick response and perfect formula. It gives me exactly what I need. I will need to incorporate into my production file. I dont forsee any issues. Thank you!
- You are welcome
