Forum Discussion

Ding080's avatar
Ding080
Copper Contributor
Jun 25, 2022

EXTRACTING DATA FROM DATE RANGES

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

 

Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jun 25, 2022

    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.

Resources