EXTRACTING DATA FROM DATE RANGES

Contributor

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

 

1 Reply

@Ding080 

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.