Jun 25 2022 07:00 AM
G'DAY ALL,
I have a worksheet with a bunch of trading info on it. Im trying to extract yearly totals of various data to add onto a dashboard. I'm having trouble with the formula..
For E.G. adding the amount of deposits made during the 2021/22 financial year - (screen shots included)
=SUMIFS('MY TRADING JOURNAL'!$D$11:$D$1070,'MY TRADING JOURNAL'!$C$11:$C$1070,"DEPOSIT",">="&G14,"<="&EOMONTH(G14,J14))
image 1 is where data is tabled
image 2 is where the data is recorded
Jun 25 2022 07:17 AM
Perhaps you mean
=SUMIFS(
'MY TRADING JOURNAL'!$D$11:$D$1070,
'MY TRADING JOURNAL'!$C$11:$C$1070,"DEPOSIT",
'MY TRADING JOURNAL'!$B$11:$B$1070, ">="&G14,
'MY TRADING JOURNAL'!$B$11:$B$1070, "<="&EOMONTH(G14,J14))
maybe something else, hard to say without sample file.