sum of item by mnth

Hi
I have 2 worksheet 1 cash flow the second one g journal . In the G job1urnal sheet column B is dates c desc d column debit e column credit and f column amount. the cash flow sheet column b has various items starting from b13 to b19 and row d 2 onwards are dates . what I am trying to do is to check the g journal sheet for items in column e that matches cashflow sheet row b13 to b19 , then tax items in column d of the journal matches b12 of the cash flow and then for the period in the g journal in column b the month that matches the row 2 of the cash flow. eg the row highlighted in red (row 82) shows the date as 12-apr-23 in the b column tax in the d column capital mall in e column and 1000 in the f column. as these match with the row b19 in the cash flow the amount of 1000 is shown in d 19. I tried the sumifs but could not geet the desired result. any suggestions
Shamsu

Hi
the row 19 gets filled correctly but when i copy to the other rows in the same sheet cashflow i get 0 balance shown . pls advice
Shamsu

the g journal file is big the rows extends to 1000 . if required can send the file but basically it is the same format , the names shown inthe cash flow chart are the same as inthe g journal

HI
the g journal file contains various items. what I want is that the item under tax in the d column related to item in the e column against the date in b column
be shown in the related month in the cash flow worksheet. eg g journal has in b82 date 12-apr-23 date in the D 82 column it has "tax" row e 82 has capital mall and in the f82 row it has 1000. a formula is required to check the column b19 in cash flow to match the e 82 in the g journal and also if the d82 in the gjournal is related to tax and check the months shown in b82 in g journal and d2 in the cash flow. if these match then 1000 shown in the g journal f82 should be shown in in b19 against capital mall. similarly for the other itmes. AliGWNs formula worked for the b19 row but when the formula was copied to other rows in the cash flow 0 amount was shown . the figures shown in r14 in the cashflow are manual entries to show the tax figuers in
under the respective months.The files was copy of the worksheet I use and hence the link

Could use this formula.

Formula:

Please Login or Register  to view this content.

My apologies to AliGW . she was perfectly correct. I had inconsistent data in the g journal worksheet. After correction of the same he formula worked as required. thanks also to the other for bearing with me
Shamsu