help me please kind people of the forum!
I have a spreadsheet with column b 'Status', column r 'date' and column j 'value'.
What I need to do is total value of the entries where the date falls between each of the fiscal quarters for a particular status.
So I want to end up with
Q1 = $200.00 for status 4
Q2 = $500.00 for status 4
etc....
is this possible and if so how?
I am a complete novice
I have a spreadsheet with column b 'Status', column r 'date' and column j 'value'.
What I need to do is total value of the entries where the date falls between each of the fiscal quarters for a particular status.
So I want to end up with
Q1 = $200.00 for status 4
Q2 = $500.00 for status 4
etc....
is this possible and if so how?
I am a complete novice