sum with text and numbers

  1. W

    Sum a range if range of cells contains a specific word in a text string

    Hi I am trying to figure out what appeared to be a simple formula however I thought wrong. Does anyone know how to have a SUMIF apply if a cell contains a certain text? Here is the formula that I have now, which is not working... =SUMIF(AJ1:BC1,"=*Reserved*",OR("=*Actuals*"),AJ2:BC2) What I...
    • wakefield101
    • Thread
    • formula & macro if statement if statement alternative sum with text and numbers sumif
    • Replies: 7
    • Forum: Excel Questions
  2. C

    totalling a sheet when cells contain text and numbers

    Hi, I'm using Excel 2010, I have a personnel tracking sheet that tracks an entire year for each employee by day and pay period. If a person calls out sick the cell is coded with SCK or sck and the hours that they are out ex: SCK 8 or sck 10.5 or SCK3.5...(some supervisors put a space after...

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