CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Dhiraz Singh
Dhiraz Singh

Reputation: 11

How To Sum a Column If Another Column Have Some Text String Within Date Range

I have a bank account statement and I wanted to sum specific types of transactions of every month

Column B has dates and Column C has transactions description and I wanted to sum Column E only transactions which have P2M and NBSM Types of transaction

This is the formula that I used but This formula sums only 1st searched text string not 2nd

=SUMIFS(E:E, B:B, ">=01/09/2023", B:B, "<=30/09/2023", C:C, {"*P2M*","*NBSM/*"})

This is the Google Sheet Table

Upvotes: 0

Views: 51

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 29982

You may test:

=arrayformula(sumifs(E:E, eomonth(B:B,),"=30-Sep-2023", --regexmatch(C:C,"P2M|NBSM"),1))

Upvotes: 0

Related Questions