Accounting for Vat. I want to show standard rate purchases etc.
I want to add the figures in a row depending on the code in the column at the end of the row. There are multiple rows i would like this to add up, however i would like them added up into one single cell. showing the results for just that code.
so:
excel.jpg
I would like the totals to show:
Can anyone help with this?
Last edited by chris-streeter; 10-30-2013 at 09:14 AM.
Try this in B13:
=SUMIF(F$3:F$8,A13,$B$3:$E$8)
then copy down.
Hope this helps.
Pete
This nearly worked. T1 total only came to 10 though =/
I'm determined to get it!
Any other ideas??
Last edited by chris-streeter; 10-30-2013 at 09:30 AM.
Try
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sumif the way Pete set it up was the way I was going to do it but I can't get it to work either.
The only way I can this to work is to do a sum inn column G of what appears in columns B through E, row by row, then doing the sumif with that.
So in G3 is 10 and G4 is 5, both for T1, etc for T9. Then this works...
=SUMIF($F$3:$F$8,A14,$G$3:$G$8)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Re: SUMIFS problem
Try
Formula: Select Code copy to clipboard
=SUMPRODUCT(($F$3:$F$8=A1
This is perfect thanks!!
Make a Pivottable.
- Drag the field "Code" to Rows and the 4 Exp-field to Values.
Change the field settings to Sum for the Exp-fields.
Create a calculated field, and the formula for the field is: = Exp A + Exp B + Exp C + Exp D
Now you can see the totals for all Codes or filter a specific Code.
/Robert
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks