formula problems

  1. R

    Simple monthly cash book formula problems

    Hi I am trying to put together a simple cash book to run from month to month. Does anyone know what formulas I will need to put into columns J & K to calculate row 3 to 9. I have gotten so far but I am having trouble with rows 8 & 9. Thank you. <colgroup><col width="24" style="width: 18pt...
  2. K

    Shift totals according to a standard Time Clock

    My goal is to differentiate a standard timecard's hours into three shift totals. My Shifts are 7:00 am to 3:00 pm, 3:00 pm to 11:00 pm and 11:00 pm to 7:00 am. (7-3, 3-11, 11-7) I want to be able to show my "Check in/Check out, Check in/Check out" in four columns to the left and then on the...
  3. H

    Problem getting COUNTIFS formula working

    I'm trying to write a formula that will count all dates between Monday and Friday of this week and the value in the adjacent column in not equal to "Fully Received". I know what I want to do and a general idea of the formula I need to use, but I can't seem to get the syntax right to get it to...
    • Harry12345
    • Thread
    • countifs countifs syntax help! excel 10 formula parse error formula problems
    • Replies: 5
    • Forum: Excel Questions
  4. R

    Problem with Sumifs and Multiple Criteria

    Hello, I currently have a workbook where I have two tabs. The second tab is a copy/paste from an export where the columns will remain the same though the length may differ. I have the following formula that works great for getting the hours an employee worked on a certain project. =SUMIF('ADP...

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