count formula

  1. N

    Excel Formula to count no. activities across number of days and time. Array formula?

    HI there I am tracking the daily activities of staff to see where they are spending the majority of their time and where their pain points are. I have a tab full of data that has been entered in intervals and i want to be able to count the differerent users activities across the whole time...
  2. C

    Count Formulas and Conditional Formatting

    I have a spreadsheet where I want to express a progress bar of how many fields have "Yes" marked in them. The yes is entered in fields with Data Validation on them. I've used the formula =COUNTA(C4:C78)/((COUNT(C4:C78))+(COUNTBLANK(C4:C78))) however the output is coming up with an incorrect...
  3. B

    Counting in groups or bunches

    Hey guys, I am trying to create unique SKUs for a data set I have. What I would like to accomplish is to create a new SKU for every new product. These SKUs should be numerical but I cannot use the drag tool or a basic formula because each product takes up anywhere between 2-50 rows. Each...
  4. D

    I need help on count formula....

    Hi I'm using Excel 2007 and I'm having a problem on how to formulate count formula, I have 2 sheets first is the master list and the other is the summary list that is connected on the Masterlist. Excel WorkbookABCDEFG1ProductsDate DeliveredLocation of DeliveryDelivered...
  5. D

    Help me in coding formula....

    i am using excel2007 and i'm making a database system here is want... this is my first sheet, the input sheet. Excel WorkbookABCDEFGH12Code No.3DEPARTMENTS4DepartmentHR5SL for Sales6Project TitleMK for Marketing7FN for Finance8Created byOP for Operations910Date...
  6. S

    Count Formula Needed

    I have a table, A1:B20. In column A I have names, Chris, Steve and Mat. In Column B I have differing values associated with each name. For example: Chris - £20 Steve - £45 Mat - £10 Steve - £45 Chris - £25 Mat - £30 Mat - £15 I need a count formula that adds up the total value assigned to each...
  7. T

    Formula Help - Count

    Hello, I am trying to count how many days a person has been in their current location. See example below. I have the formula to find current location as =LOOKUP($A$2,$D$2:$H$2,D3:H3) A2 is Todays Date <TABLE style="WIDTH: 419pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

Watch MrExcel Video

This Week's Hot Topics

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
Top