Sum based upon day month or year

ChartTrades

New Member
Joined
Sep 8, 2023
Messages
2
Been banging my head trying to figure out how to accomplish this. Seems like it should be pretty simple but all the articles I've read fails to get me there. I have a spreadsheet with the following columns

Trade number (numeric)
Date (date)
shares (numeric)
Entry (money)
exit (money)

What I would like to do is be able to select a month, year or specific date and get the sum of the appropriate along with getting the sum for each row entered. Is this possible?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Been banging my head trying to figure out how to accomplish this. Seems like it should be pretty simple but all the articles I've read fails to get me there. I have a spreadsheet with the following columns

Trade number (numeric)
Date (date)
shares (numeric)
Entry (money)
exit (money)

What I would like to do is be able to select a month, year or specific date and get the sum of the appropriate along with getting the sum for each row entered. Is this possible?
P.S I am using sheets if that matters....
 
Upvote 0
P.S I am using sheets if that matters....
Yes, that matters. While there are many similiarities between Excel and Sheets, they are not the same (there are differences).

Please do NOT post Sheets questions in the "Excel Questions" forum. Please post them in the "General Discussion & Other Applications" forum, as mentioned in the forum description.
1694194205944.png


I am moved this thread for you.
 
Upvote 0

Forum statistics

Threads
1,215,124
Messages
6,123,187
Members
449,090
Latest member
bes000

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top