This is a repost of my original question: I am trying to not use any add-ins or BI tools. I'm wanting to use a pivot table to create a histogram (graph) that shows: A.) Count of new action items for the week B.) Count of action items resolved for the week C.) The cumulative count of unresolved action items for the week My columns are in a table called tblMain and I figured I could get by using columns [ID] (a unique ID number) and [DateComplete] (a short date). Filtering out the action items that weren't completed is easy enough using a "null" qualifier for the da...

This is my original file Col A Col B Col C Col D Name Jan Feb Mar Deepak 1 0 Deepak 2 1 3 Deepak 1 Tata 0 0 2 Tata 2 Ambani 5 2 Ambani 1 Need to add the count of duplicate - so the result should be as below Name Jan Feb Mar Deepak 4 1 3 Tata 2 0 2 Ambani 6 2 any help is appreciated in advance Deepak Col E Col F Col G Col H Name Jan Feb Mar in cell F2 put this formula =3DSUMIF($A$2:$A$7,$E2,B$2:B$7) copy it down and across. On Jan 21, 12:19=A0am, Deepak <...

Hi, I have some no's in a column,in which some are duplicating & some are unique no's.Like 825 921 941 921 822 825 941 421 Now i want to count the unique no's in a column. The result should be 5 for the above example. Note : can the result be taken out in a cell instead of using an another column. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ Enter the array formula: =SUM(IF(LEN(A1:A100),1/COUNTIF(A1:A100,A1:A100))) to exclude 0 values, or as: =SU...

Hi all, There are two worksheets in my workbook. The first sheet is used to record data entry stats. In the first sheet, the first column contains the data entry date, and the second column contains the data entry name. I am using the second sheet to maintain the stats of each data entry person on a monthly basis. How do i achieve this without using macros. Thanking in advance. Regards, Rohit On May 9, 12:20=A0pm, rohit <desai.rohi...@gmail.com> wrote: > Hi all, > > There are two worksheets in my workbook. The first sheet is used to > record data entry stats. In the first ...

Good evening: Is it possible to count how many times a string of numbers appears in a column? I am working on a project that has approximately 1000 telephone numbers. I need a count on how many times a particular number appears in a column. Thank you in advance John Is it really a "number" or is it a telephone number complete with hyphens? =COUNTIF(A1:A1000,2345) if number =COUNTIF(A1:A100, "555-1212") if text In either case the last argument can reference a cell: COUNTIF(A1:A1000,B1) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps ...

I need to know if you are supposed to be able to add in count totals into an open Physical Inventory from multiple stations at the same time. We disperse staff throught our store to count items in several storage areas. I then open a physical inventory count and ask staff to open Store Operations, open the physical inventory and add their counts in. However, it appears the when you hit ok it OVERWRITES anything in the count instead of ADDING to it. Is this by design or something wrong with our system. Try using the import button inside a physical inventory count. It gives options to ov...

What is the format of the excel function to count cells with specific text in the cell. I have a column on my spreadsheet that has some data in the cells starting with the letters "wo". There are more letters and numbers after the letters "wo". I need to count the cells that start with the lettes "wo". What is the function and format of the command to count the cells on my spreadsheet with the letters "wo" Thanks Confused confused, here is one way, =COUNTIF(A1:A10,"wo*") -- Paul B Always backup your data before trying something new P...

Hi, I have a question here, appreciate any help. Prod ID Jan Feb Mar.... Prod A 10 5 3 Prod B 3 - - Prod A 4 7 1 Prod C 5 2 7 In Cell A8 = Prod A At cell B7, it is a data validation(drop-down list) for Jan~Dec In B8 cell, I need a formula to calculate When Prod ID = Prod A and when month selected is Mar, the sum, ie. result is 4. In C8 cell, I need a formula to calculate When Prod ID = Prod A and when month selected is Mar, the count if value is > 0, ie. result is 2 I know I may have to use sumproduct, som...

What is the proper syntax to concatnate Countif function Say you want Colum A = to equal either 100 or 200 and colum B should be a date between Jan 1, 2008 and Dec 1 2008 List the criteria in some cells: D1 = 100 D2 = 200 E1 = 1/1/2008 F1 = 12/1/2008 =SUMPRODUCT(--(ISNUMBER(MATCH(A1:A20,D1:D2,0))),--(B1:B20>=E1),--(B1:B20<=F1)) -- Biff Microsoft Excel MVP <James@aol.com> wrote in message news:s0q325pegdibvc7a9ktgqii597omoki040@4ax.com... > What is the proper syntax to concatnate Countif function > > Say you want Colum A = to equal either 100 or 200 and colum...

I have a table with department IDs, department heads and headcount. Sometimes there are two department heads per department ID. I want to show the head with the largest staff as the leader. I've created a total query to show the count of the staff. Where can I go from there? SELECT [DeptHeadcountTable].DeptID, [DeptHeadcountTable].[Director], Count([DeptHeadcountTable].[EmployeeID]) AS [CountOfEmployeeID] FROM [DeptHeadcountTable] GROUP BY [DeptHeadcountTable].DeptID, [DeptHeadcountTable].[Director]; Try this -- SELECT [DeptHeadcountTable].DeptID, (SELECT TOP 1 [XX].[Department...

This is a multi-part message in MIME format. ------=_NextPart_000_0117_01C3C3EE.FE9B01B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Do email groups count as a "user" as far as Microsoft's licensing model? = I would think not, but not sure. Thanks, Brian ------=_NextPart_000_0117_01C3C3EE.FE9B01B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-eq...

hi all, A couple questions with inventory and sales. 1. Is it possible to setup CRM so that an order can not be created if there is 0 qty on hand? I don't want to carry a balance or do a back order. 2. Is it possible to only bring over the qty on hand from one warehouse? Currently our sales team sees items that are in our quaranteened warehouse. Thanks. We could help you solve this. www.tsinghuasoft.com "Jeff" wrote: > hi all, > > A couple questions with inventory and sales. > > 1. Is it possible to setup CRM so that an order can not > be created...

I am creating a label program where i can select and product from a table and store the selected item to another table so i can print the selected item. I was wondering if I could enter a value and press the print button so the program will automatically print the qty entered in the qty field. Thanks -- George Sydney Frustrated programmer George, Please describe a bit more... Are you printing one label, a certain number of times? It sounds as though you want to print unique labels, but with a common Qty? Please show us some sample data, and what you would like to see on your...

I saw a demo by Microsoft technician last year, who demo how to enter (-) qty in the SOP Order form while using GP 8.0. This feature allow user to handle a credit transaction and a debit transaction on the same order. In prior version, the return must be done under Order Return. How can I activate this new feature? When I tried to enter a (-) qty in Order form, the GP 8.0 still do not allow me to enter it. Thanks! On a quote or an order you can only enter a negative unit price, not a negative quantity. On an invoice you can enter a negative quantity OR a negative price, depending ...

I apologize if this is a duplicate submission. I have a spreadsheet of data with two columns of data for which I need to summarize on another spreadsheet. Column A lists makes/models and Column B counts the number sold. The original spreadsheet will contain multiple duplicate entries of the same makes/models for which I need to summarize. Ex: Column A Column B 7444 loader 2 Which formula would be best for this project? Thank you! SUMIF() is probably what you want. You can either set up several cells with all possible combination ...

Hi, I'm after a (fairly) complicated formula here. I have two three columns I'm interested in. Column 1 contains three different values ("CGF","GGF","SGF"), column 2 contains "Yes"/"No" and column 3 contains "Pass"/"Fail". I'd like to count the number of times in the first column ($C:$C as I don't know how many entries there are) for each value (GGF,CGF,SGF) that have a "No" in column 2 as well. I've tried This: =COUNT(IF(($C:$C="GGF")&($D:$D="No"),1,0)) but with...

Hi Excel Forum, original ThreadID (http://www.excelforum.com//showthre...threadid=239331) I have tried a Pivot Table as was previously suggested but the result included the Filtered Hidden Rows as well as the Filtered Visible Rows I require only the data of the Filtered Visible Rows. The Filtered dat will be constantly changing and a solution that can be performe on-the-fly would be more suitable. Is there any way of providing a solution using Formula or VBA to coun the individual departments and then count the subset of department within the Filtered Visible Rows to ultimately provide a s...

Is there any way to import stock count data with integration manager? There is no adapter for that transaction but I noticed a Blue Moon document that said it could be done. There are 3rd party products from Compass and Blue Moon that will import stock count data from a flat file but I would like to avoid adding additional software. Thanks. Lou You should be able to user IM to import them as Inventory Adjustments (Item Transaction Entry). Select 'Variance' as the Document Type to differentiate it from other adjustments, if desired. Frank Hamelly MCP-GP, MCT, MVP E...

I would like to add a textbox (txtCheckedForms) that shows the number of checkbox fields are checked on a form. Is there a simple way of doing this? The only thing I've come up with so far is something like this... If chkField1 = True then varCheckedForms = varCheckedForms + 1 if chkField2 = True then varCheckedForms = varCheckedForms + 1 .... ifchkField50 = True then varCheckedForms = varCheckedForms + 1 txtCheckedForms = varCheckedForms The problem is, I have about 50 checkbox fields on my form. That would take a long time and a lot of space! Also, the fields aren't actually ...

For a range of cells containing percentages, how can I use COUNTIF to count those cells whose values fall between 90% and 110% ? You could count the number >= .9 and subtract the ones >1.10 =countif(a1:a10,">=.9") - countif(a1:a10,">1.1") Or you could count the ones that are trapped between those numbers: =SUMPRODUCT(--(A1:A10>=0.9),--(A1:A10<1.1)) =sumproduct() likes to work with numbers. The -- converts trues and falses to 1's and 0's. KG wrote: > > For a range of cells containing percentages, how can I use COUNTIF to count > ...

:confused: Hi, I have spent countless days trying to find a formula that will allow me to find duplicates across Multiple Sheets within a single workbook. All resources I have checked only allow duplicate finding formulas for A single Sheet. I have multiple sheets 1 to 31 representing a month in which I have a column of phone numbers. i want to be able to know from sheet to sheet (Day to Day) if I may be retyping a number from a previous day. Thats why I need to have a formula to check acrosss the sheets for duplicate numbers... even better if I can have the duplicates displayed on a new...

I am attempting to count the number of times a specific value range occurs in a row throughout a large spreadsheet. For example, I have three values in multipe rows: A1=10, B1=20, C1=30, A2=20, B2=10, C2=30. A3=50, B3=50, C3=50 I want to create a formula that will allow me to count the number of rows that contain 50,50,50 within a large area. Here's an array formula that will help you count unique instances SUM(1/COUNTIF(data_range,data_range)) CTRL+SHIFT+ENTER to activate the array -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips &quo...

When sorting by a column header in Outlook (i.e. Subject, From, etc...) the items are grouped by the header and the count of items is displayed as (x items). Is there then a way to then sort by count of items so the largest groupings with the most items are at the top? This could really help with cleaning up my Inbox as I could identify groups of messages with the same subject or from some person ordered by the largest grouping and work on those first. Any help is greatly appreciated!! -- sramsay As far as I know, no. "sramsay" <sramsay.34d99b8@outlookbanter.com> wro...

I have a large spreadsheet (Excel 2000) that contains more than 1,000 rows. There are two columns with dates and I want to count the workdays, excluding weekends and holidays between the dates in each row. Can I do this without having to put the dates from each column that I want compared in the formula? I want to count the workdays between whatever dates are in these two columns. Use the NETWORKDAYS worksheet function. HTH Jason Atlanta, GA >-----Original Message----- >I have a large spreadsheet (Excel 2000) that contains more than 1,000 rows. >There are two columns with d...

Hi! I have RMS HQ and a location -store1 wanted to count inventory on hand & wanted to update HQ qty for store1. I have already updated store1 qty by store manager - Inventory -physical inventory - commited qty Also, try to sync with HQ but won't update qty on HQ for store1 to new count.. New to this HQ - Appreciate all your help. Vinay - at HQ, create and approve worksheet 501 - process it at the store, this uploads the quantities after the PI up to HQ - then in HQ run inventory wizard task 190 to reconcile the qties in hq with what you uploaded on the 501 - hope this helps.......