$0.00

  1. B

    Macro to move data to a new row

    Hello, I am in the process of trying to move data within Column 15 of my Excel Spreadsheet to a new row. I will post what the Excel spreadsheet originally looks like and what I would like the end result to look like. I'll also post the Macro which I've put together. The issue right now is...
  2. D

    SUMIFS formula picking up all values instead of criteria

    https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd I have two columns. First column =age of invoice Second column = $ I want to do SUMIFS for invoices > 365 days E6 works fine for invoices 'Not Due' E7 should pick up $0.00 but instead picks up everything Not sure why..
  3. M

    show zero value

    <colgroup><col width="101" span="6" style="width:76pt"> </colgroup><tbody> POINTS BAGS WIN WE WE THEY TOTAL WE LOSS TOTAL 392 568 ($17.60) ($4.00) ($10.00) ($63.20) 551 427 $12.40 ($4.00) $10.00 $36.80 576 378 $19.80 $12.00...
  4. M

    Help with Concatenate to exclude cells with no data

    Hello, I have a spreadsheet that is concatenating multiple ranges of data to formula a note that can be copied and pasted elsewhere. Unfortunately I can't figure out how to exclude blank cells and instead I'm getting 0's in my final note, like this: <tbody> #D9D9D9[/URL] , colspan: 2"]...
  5. jim may

    Anything Look strange with this - using in Office 365 = It is Displaying $0.00 but shouldn't

    <tbody> =SUMPRODUCT((YTD_GOOG_2019_CyberSource!$A$5:$A$500='Monthly Recons-Google'!C$4)*((YTD_GOOG_2019_CyberSource!$M$5:$M$500="Settlement")+(YTD_GOOG_2019_CyberSource!$M$5:$M$500="Card Credit"))*(YTD_GOOG_2019_CyberSource!$I$5:$I$500)) </tbody>
  6. B

    Creating a new blank row and moving data to that row

    I am currently configuring a financial report which lists description data as well as financial data. I will post a copy of the layout below. What I'm looking to do, is to use a macro/vba or whatever I need to in order to allow me to create a blank row above any row which contains the word...
  7. B

    Macro to create a new row and copy data

    I am currently configuring a financial report which lists description data as well as financial data. I will post a copy of the layout below. What I'm looking to do, is to create a macro which would allow me to create a blank row above any row which contains the word Totals. I'd then like to...
  8. P

    SUMIFS Across Multiple Columns

    I have a formula that is getting out of hand. At first I found it to work without and issue but now I have to replicate it a little more frequently and its getting quite cumbesome to do so. I have Columns L,M,N,O,P, and Q that all have individual Dollars that are pulled into this sheet at...
  9. M

    index across multiple tables

    is it possible to use this layout (they are tables, I couldn't get it to paste that way) and have excel look at all the tables and return the header and amount under the header of that table only if it is greater than zero? The tables are on one tab and the results/totals are on a different tab...
  10. Photomommie

    HELP: Adding multiple textbox values (cleanup)

    I have 20 textboxes in my userform that need to be added as a "Subtotal" I have it working now, but it is very clunky and I thought there might be a better way of handling this. Here is an example of the code: Private Sub tbxPrice1_Change() Dim tbxPriceSum As Double If Me.tbxPrice1.value =...
  11. G

    Help with this formula Please

    In this formula If the [[#Totals],[BALANCE]] is $0.00, how would I write this formula not to show the 0.00’s? CheckRegister78910161836[[#Totals],[BALANCE]] Thanks in advance
  12. Q

    Using formula to calculate figures based on dates, it gives circular reference

    <colgroup><col><col><col><col><col><col><col><col span="2"><col span="2"></colgroup><tbody> Ledger No: ID# Src Account Name Date Memo Beginning Yr Balance Debit Credit Cl Daily Bal Cl Mon Bal 4-1100 GJ000327 GJ Sales 30-Sep-16 PayPal US Transactions 0 $77,477.73 ($122,046.23) ($122,046.23)...
  13. J

    daily, MTD and YTD Sales Report

    I am trying to create a Sales Report that will show performance vs last year. I have created a formula to give me yesterdays date with one cell showing the month, one the day and one the year (located in cell C1, D1 and E1 respectively) here are the formulas: =TEXT(TODAY()-1,"MMMM")...
  14. B

    Assistance required with which formula to use to create a Master sheet referencing other workbooks

    Hello everybody I am seeking so advice on how do collate a summary for the financial year of the invoice date, hours worked, the associated codes (possibly 4 per invoice), and total dollar value. Thanks in advance I generate weekly invoices with the (day In Column A), (the date in column B)...
  15. K

    Best formula for data lookup from Store#, Dept #, and Date from a lot of data

    I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across. I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of...
  16. P

    Need to Sum a column if another column contains a Letter followed by numbers

    <tbody> R04973 LEICA 2DEXC KIT & PA 20180219 $0.00 $0.01 MI $0.01 1 R05054 MISC RE-RENTAL UNIT 20180416 $0.00 $0.01 MA $0.05 5 R05065 MISC RE-RENTAL UNIT 20180419 $0.00 $0.01 MA $0.01 1 </tbody> The above is a snapshot of a sheet I run, The invoices come in labeled with an R for "rental"...
  17. J

    SUM of Data based on a Condition & Running Macro. PLEASE HELP!

    I have a very long list that I run a macro for. I need the total credit cards (Visa + Master Card + American Express) for that day. On top of that I am running a Macro and the date range is different every time. I think I need a formula that consolidates the "Date" Column so it doesn't repeat...
  18. J

    Excel Formula

    Hi all, I'm new to MrExcel I'm trying to work out which input to use for this scenario. In cell A2 i have 4 different win prices i can use So what i want to be able to do is when i enter a price in A2 it will automatically put the outlay amount in cell B2 and in cell C2 when i enter 1st i want...
  19. M

    Filter then Subtotal

    Hi all, In need of some major help for a report due tonight. The below calculations fill my table with values based on distinct customer numbers (customer numbers are in column A) I created column C, because it counts the number of actual entries (that is, a customer number found in in...
  20. T

    Check Consecutive value

    Hi , I have values for a year in excel and in the row sum i want to sum the total of 1,2,3, and in the return row if i dont have a value in consecutive months then i should minus that value from total. For ex below month 1. in jan i have 4900 however next two months the value is 0, hence it...

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