Forum Discussion
Counting the days between values if another row has a specific value(text
Hey guys, I'm looking to count the total amount of days between a lot of dates. but only if in another column a certain value is given. For example A 1-12-2020 31-06-2021 B 1-03-2021 5-05...
Hey Quadruple_Pawn,
Thanks for your reply!
Somehow it doesn't work for me, it gives me a value error when I use:
=SUMPRODUCT((B:B=S4)*(I:I-E:E))
=SUMPRODUCT((B:B="S4")*(I:I-E:E)
It works in my spreadsheet if i enter "S4" instead of S4 in the formula.
- Hey Quadruple_Pawn,
S4 in this case was a direction to a cell(that had the wanted value). This solution somehow still gives a value error, although I don't understand how. No matter though, I ended up solving the problem by taking an extra step of counting the days in between seperately. Thanks for your time 🙂
Kind regards