Hello,
I'm trying to create a formula which would give me the total amount sold. So for example I'm trying to get a formula which would say if column A = 'Sale' and Column B = 'Office' then total amount for office would equal x or in the case of the example £373,000.
Column A Column B Column C
Sale Office £123,000
Lease Office £21,000
Sale Office £250,000
Sale Retail £120,000
Hope this makes sense. Can anyone help?
=sumifs( C:C, A:A, "sale", B:B, "office")
or you can use cells to put Sale and office in
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
upload a sample workbook with desired results manually put
Teach me Excel VBA
Here is a link to a sample - https://www.dropbox.com/s/9nrpnvabfr...heet.xlsx?dl=0
sorry, and it is the sold office amounts I am trying to get a formulae for
did my formula NOT work ?
your example is different on the spreadsheet
=SUMIFS(D:D,A:A,"sale",C:C,"office")
Thats does thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks