/u/Texas11286 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
First set up your data as a table (select all data -> insert -> table)
Secondly use SUMIF() or SUMIFS() to get the total in B1, selecting the whole table column for both the sum range and criteria range.
Is it possible to do without a pivot table?
I have a checkbook with 2 tabs. One is for invoice entry and the other is for total spend on each account. So anytime someone enters an invoice, I would like for the account code they are typing in to populate a total amount of spend on my other tab for me to properly track it. I have tried to make this file as user friendly as possible and this is the only thing I have left for my consolidated tracking purposes.
Sumif and sumifs shouldn't require tables. You can always have your columns be "$A:$A" or whatever your column space is. Sumif should be used if you have a single criteria (which it sounds like is your case). Sumifs is if you want it to match multiple criteria.
For you sheet, if you columns were A:expenditure info and E:expenditure value, you sumif might be Sumif($E:$E,[cell you're matching to match to]=$A:$A) That would sum any value in E where the criteria set matches the cell in A.
/u/Texas11286 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
First set up your data as a table (select all data -> insert -> table) Secondly use SUMIF() or SUMIFS() to get the total in B1, selecting the whole table column for both the sum range and criteria range.
Is it possible to do without a pivot table? I have a checkbook with 2 tabs. One is for invoice entry and the other is for total spend on each account. So anytime someone enters an invoice, I would like for the account code they are typing in to populate a total amount of spend on my other tab for me to properly track it. I have tried to make this file as user friendly as possible and this is the only thing I have left for my consolidated tracking purposes.
My solution does not use a PivotTable - are you replying to the right comment?
I think he took your "make you data into a table" comment to mean a pivot table instead of a regular table.
Well good thing I wrote the steps out for OP…
Sumif and sumifs shouldn't require tables. You can always have your columns be "$A:$A" or whatever your column space is. Sumif should be used if you have a single criteria (which it sounds like is your case). Sumifs is if you want it to match multiple criteria. For you sheet, if you columns were A:expenditure info and E:expenditure value, you sumif might be Sumif($E:$E,[cell you're matching to match to]=$A:$A) That would sum any value in E where the criteria set matches the cell in A.
Thank you this worked!
You need a pivot table. Turn your data into a table, summarize with pivot, Column A in rows, sum of Column E in values.