countif 2 conditions met

I'm working with a file that has multiple worksheets for different departments that contain Purchase Order information and payments are entered by date moving vertically across the spreadsheet as they are received. I need to be able to easily identify those Purchase Orders that have not...

Hi I would like to count how many instances cells within column C do not equal a named range with a second criteria, something like this: =countifs(C:C,"<>"&NamedRange, D:D,"1") Is this possible? Many thanks

I want to find the sum of the range within the sector within the zone but only summing unique values. For example, I want to find the sum of the Codes within Sector Ice Cream, Zone 1. However I don't want to count duplicates within that range. $63 Dollars should be the total of Sector Ice Cream...

Hello I am new in VBA and I am looking to build a macro to count the number of stores a responsible (let's say K) sells to, for each brand. In this example, K sells to 1 store the brand 1 and 1 store the brand 2. (so a total of 3 sales but to 2 stores only). Any help would be really appreciated...

This seems like it would be a simple formula but I keep getting a #Value error when I try it. Trying to get a count based on criteria in Column A in addition to Row 1: DATA: <tbody> LOCATION P01_2018 P02_2018 P03_2018 P04_2018 P05_2016 NO 1 1 1 1 1 USATL 0 0 0 1 0 NO 0 0 0 0 0 NO 1 0...

Hi, I am looking for a formula route to return a count of accounting dates based upon a match of corresponding cells. I’ve had a look through the forum but can’t see a similar answer, although I have seen a few with more complex analysis. The Reference data is no more than 100 lines. Sadly...

Using cell references only, how would I count the number of times a value appears in a range and also matches another (fixed) criteria? Example: I want to know how many times the value in H3 (table2) appears in table1range B2:D15 where their SS7 code is also the same as that in J1 (table2) I...

I need to make a formula which counts dates and times as one rather than trying to count them manually: The details are: Sheet1 - Column G contains the date (29/07/2017 or 30/07/2017) and Column H contains the time (formatted as h.mm AM/PM) In a separate sheet I have a "chart" with dates at...

Hi guys, I´m new to the forum. I´m having trouble with a formula that would allow me to search for the frequency of a column conditioned to anothe column, I can´t use pivot tables since the data comes from a Query from SQL that needs to be automated on excel. <tbody> Count Merchant...

Hi I have a code, which pulls data in few columns from a given data using RandBetween. To remove duplicates in column (except "X"), a code is given below: This code is not giving the desired results, that is it stops itself before checking for any duplicates. Kindly help in correction of this...

Hi all, I was wondering if someone could help. I have a list of Participants (Participant 1 down to Participant 30), and each participant has received feedback from a number of their colleagues (Peers, Team Member, Senior Colleagues etc.). What I am looking to do is to use a formula whereby I...

Hi, please i need to be count numerical values less than 3 and greater than 3 on base of locations. if find duplicate location in the rang that should be equal to zero or empty. Example . Italy have 3 numerical value (9,2,4) hare is one less than 3 and 2 more than 3 and other duplicate Italy is...

Hi, I'm facing an issue with respect to running an index match on a set of datapoints. Description of the problem is as follows: <tbody> Name Skill1 Skill2 XYZ BPM Leadership ABC Content management Network operations </tbody> <tbody> Assignments Skill1 SKill2 SKill3...

Hello all, I am trying to populate another worksheet based on a worksheet that is given the month and the year. I then want worksheet 2 to count this data and fill in the months and how many projects should be live within that date... Worksheet 1: <tbody> Go-Live date January (1) March...

Column A Column B Tests EarlyStart FST_NANA 17/05/2016 SWCPITDIS 17/05/2016 SWCPITCOMP 18/05/2016 SWCPITDIS 18/05/2016 ZFLOW20 16/05/2016 FST_NANA 16/05/2016 POOL 16/05/2016 POOL 16/05/2016 POOL 16/05/2016...

Hello everyone, I wish there is someone who can deblock myself from this situation: I want to do this: =Countif(range,"5")/countif((range,"*")*6)). In natural language sounds like this for me: Count in that range how many times you find a value. Be that 5 for exemple. After you found how...

Hello one and all, Help if you will please. I'm trying to run a formula that will count certain cells given that another cell is filled. Please see below example: <tbody> A B C D E F 1 Name SOD SHD HSD PART ORDER NO 2 123 1 65189 3 456 12 4 789 x 59723 5 123 1 6...

:confused: I am a little overwhelmed with all the info out there :( I am sure there is a simple solution to this but I can't find it... I want to count the number of times a value appears in a column *if* a cell in another column for the record (row) is a specific value. I already know about...

Hi, I am looking to work out if a list of items have been Completed, Due or Overdue. For completed, it should be in last: 24h, 48h, 72h, 5 days, 10 days. For Due, it should be in next: 24h, 48h, 72h, 5 days, 10 days, more than 10 days. For Overdue, it should be overdue by: 24h 48h 72h, 5 days...

We have a register keeping track of all our counselling referrals and I need to keep track of numbers of unallocated patients based on differing sets of criteria, as below: <tbody> First name Surname Funding Counsellor/status Angus Smith Bolton Franklin Beaumont Smith Hitchcock...