spend

  1. P

    Help Please

    How do I write a formula for the yellow box that will return a category in column D from the spend value. <colgroup><col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"...
  2. S

    Sumifs

    Okay let me see if I can explain this...I am looking to match Supplier Name #sheet 1 to Supplier Name #3 If those two suppliers match,then look for the Known Spend, If Known Spend is equal to "Y", then look to see if the they fall within two columns with dates. Now if that all information...
  3. J

    Dynamic columns tracking duration of projects i.e. 6 months in one and 10 months for another

    OK so trying to create a "Spend Profile" template to track spend versus budget that I can use for each project that I have and will have in the future. I have created a sheet to capture basic information for the project (name, approved budget, start date, end date, etc.) and a "spend profile"...
  4. N

    Help, formulas/goal seeking

    Hi guys, I have this problem and cannot solve. So I was hoping on some help. I can solve this problem with goal seeking, but this is not dynamic. Maybe you have a better solution. So I have the following: <tbody> <tbody> Total budget </tbody> <tbody> campaign1 </tbody> <tbody>...
  5. A

    Weighted Average

    I am trying to find out how many shares of stock I can purchase based off the following: A) Total money available to spend on stocks is $100. B) I want to buy two stocks. C) Stock #1 price is $10. D) Stock #2 price is $20. The question is this... How many shares can I buy if I can only...
  6. V

    VBA code to display top selected number of rows in pivot table

    Team, I got a requirement where I have to display top number of suppliers dynamically. The top numbers will be chosen by the manager and I should display the data in pivot table. As my dataset will have more than one supplier spend, I have to use pivot to cumulate the spend. Do help me to...
  7. N

    Sumifs formula in excel is always returning 0

    I am trying to get the customer spend for a particular product using Sumifs formula :- =SUMIFS('UK Raw Dump'!$X$2:$X$2627,'UK Raw Dump'!$C$2:$C$2627,'Customer Profile - EMEA Region'!B2,'UK Raw Dump'!$AY$2:$AY$2627,"Evault") Where Column X is the spend for the month of September, C is customer...
  8. megera716

    Conditional formatting data bars

    I don't know why I can't figure this out but I've googled every incarnation I can think of and I can't find what I'm looking for. I have this set of numbers in columns J:M. I want a data bar in column N that is a percentage of spend vs budget (Column L/Column K), with a label of the actual...
  9. M

    Sum based on multiple changing criteria

    Hi Everybody, I'm not sure how to phrase this one, so please bare with me whilst I do my best to explain! I've got a complicated spreadsheet for tracking project expenditure by stage, time, type of spend etc. In this spreadsheet you can choose which months you will be in which particular...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top