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 t...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
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