Hi,
=SUMIF(J14:J312,"*a+*",F14:F512)
Using this formula i'm fetching 'values' from column F based on 'text input' in column J
but when I apply date filter it still shows the same 'total sum' value as without it.
Can some please update this formula so that it doesn't take into account the values/rows which are out of filter range.
Bookmarks