Saturday, June 16, 2018

yogi_Compile Monthly Statement By Item From Monthly Expenditure Sheets

Google Spreadsheet   Post  #2463

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jun-16-2018

question by: Edison Wu!topic/docs/Cs2NyUuZVI0;context-place=mydiscussions
Data validation question
Hi all,

I want to make a budget spreadsheet. I made a data validation drop-down list of the items so I can choose, for instance: I choose "Grocery" from the drop-down list and enter the value next to it. 

But is it possible to store the value and output the value on another sheet. Like I put $25 next to "Grocery" on day 1, and put $10 on day 2. Is it possible to show the sum of the value on "Grocery" and output it?

Thanks a lot.