Hi Experts,
Good day
I have column A with dates, column B with Descriptions and column C with Amounts
DATE DESCRIPTION AMOUNT
27-Apr-22 ABCD 200
27-Apr-22 ABCD -1000
27-Apr-22 CT ABCD -3000
26-Apr-22 ABCD 1000
26-Apr-22 ABCD 600
26-Apr-22 CT ABCD -480
26-Apr-22 ABCD 25
26-Apr-22 CT ABCD -2020
26-Apr-22 ABCD 2700
25-Apr-22 ABCD 1986
25-Apr-22 ABCD 40
I'm looking for a formula to SUM the amount from specific date, description (partial keyword "CT")
Example :
I've input 27-Apr-22 in E1, in F1 i need to answer for 27-Apr-22 total of negative amount only for CT ABCD
I manage to find the figure for negative amount but still need to sort out the description part
Attached herewith my sample of workbook
Thanks in advance
Bookmarks