Hello everybody,
I am using a German version of Excel for Mac. So don't be hating if I translate something wrongly.
My issue is that I have a dynamic table (ex. Tab) where I want to get the sum of one column (ex. Net) if the date of Tab (ex. date) is smaller than today minus the day of payment [ex. paydate].
So i wrote
=sumifs(Tab[Net];Tab[date];"<="&today()-Tab[paydate]
somehow sumif doesn't care about my dynamic column paydate. If I change that Tab[paydate] to a number (ex. 1-100000) it works. but with the dynamic column name not.
Can someone could help me please?
I would be very thankful.
Greetings DerNeuling
Bookmarks