Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


maoriboy

1034 posts

Uber Geek
+1 received by user: 562

Trusted

#305898 12-Jun-2023 12:18
Send private message

Hey there hive mind. Very much a beginner when it comes to spreadsheets and I'm trying to figure this one out.


Have a basic spreadsheet with clients name and monthly spend. The boss wants to be able to select a client and pull the total from a select month or months. Is there a way that this can be done using something like dropdowns, graph or pivot table? It needs to be really simple for someone to change the client and selected months. 


This is just a very simple example of what the sheet looks like. Any advice would be gratefully accepted!



 


 






Create new topic
gcorgnet
1096 posts

Uber Geek
+1 received by user: 273

ID Verified

  #3088982 12-Jun-2023 13:25
Send private message

pm'd you


Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.