countifs

Hello Excel Community, Wondering if someone might have some insight into the following. I am trying to find duplicate values based on a criteria which i will explain below. I am attempting to use the countifs formula to review but i keep getting an error and I cannot figure out what might be...

Hello all. I'm having a problem doing a simple COUNTIFS formula. I have to automate a spreadsheet that counts rows if it has the corresponding city, but only if the date is the date from another cell. Lemme post the table bellow: ABCDE1DatestampLocationCurrentDateCityCount221/07/2024...

Hi All - New here so please bare with me. I would like to count the number of times a cell containing "PB" would appear for a set individual between two dates. For example in Image attached: 1. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and...

Hi All, Could you guys please help me on writing a formula to countifs based on the following criteria : 1) by position 2) How many "D" and 3) from the range of the date between x and y ? Thanks All...

Hello, Would really appreciate some help on this, i've been struggling with it all day. I've mostly tried variations of index/match, countifs, sumifs, but it i'm having trouble factoring in the different criteria, so i'm basically lost. I'm basically looking to create two formulae. one that...

I'm a little puzzled, I'm sure because it's that I'm not understanding something correctly. Say that I've made a pivot table from the following data: Month Company January Company A January Company B February Company A February Company B February Company A February Company B...

Morning all. Relative Excel novice, so I just don't know where to start with figuring this out. I have an Excel file that's getting too large and need to make a new one for the year it seems. But I have a COUNTIFS formula in column Q that counts the number a times a street address and city...

Dears, I have a sheet containing a mini table in different groups, and the formula COUNTIFS gives me a #Value!

Hello i am trying to find a way to take the below countifs statement and update it to where through the range D23 to D8622 it counts the number of "X"s where the cells in the range B23 to B8622 equal "Section Mark X" there are multiple cells down the B range where the cells have Section Mark X...

Good evening fellow excelers, Is there a way to write an XL formula that will count non-formulas in a range? I know this is gotta be simple to do, but I just can’t seem to wrap my mind around how to do it after about half an hour to an hour of trying. Thanks for any consideration to this...

I am building an NBA stats workbook where I have separate sheets for each stat (points, rebounds, etc.). I am tracking this data in one sheet and I have the date of the game for that player in column A. One of the stats that I am tracking is the difference between the player's average for that...

I have been working on a statistics model for NBA players, where I track how well they do each day based on a specific number (do they score more or less than X points, rebounds, assists, etc.). I am trying to build a single spreadsheet that can reference each day that a player played and count...

Hello! Using the sample table below, which formula can I use to pull the count of "Available" cells in this text range (not a table), but only for the specific column which matches today's date? I've tried a few variations of COUNTIF with HLOOKUP, but it's not working for me. 11/6/2023...

Hi all, I want to count the cells in column 'F' where the value is >='I2' AND the Absolute value of 'E:E' > 'I7', but some of the cells in 'E:E' contain text. Excel doesn't like this: =COUNTIFS(F:F,">="&I2,ABS(E:E),">="&I7). Any help is deeply appreciated. Thanks much in advance.

hi - First post in a very long time - I'm wondering if someone could help please? I am trying to work out how we can establish our stock levels Each row would identify either a customer order - using columns for customer name and product code or an item in stock using the term "stock" and...

So I have a lot of data and someone has changed how it is imported! I needed to find how many different orders were taken by a salesperson in the month so ran this COUNTIFS(Dels!$O:$O,"BOB",Dels!$C:$C,">=01/08/2023",Dels!$C:$C,"<=31/08/2023",Dels!$H:$H,">0.00") which ran perfectly as all...

Hi I hope someone is going to have a simple answer for a countifs query i have need resolving. I have a long spreadsheet (1400 lines) which someone has 'been using' badly, and i need to count if certain words are used in a column. i need to count light fittings unfortunately the person who...

I have a column that totals the amounts of 31 other columns based on value in those cells. It works great, but there are so many rows of data that looking at a bunch of 0s for all the cells that have no data to return is eye boggling. I'd like to edit the formula to include the "IF" function to...

Needing assistance with calculating the ranking for golf scores bases on total score, and then each hole based on the hole handicap. Here's the current data I'm working with (ignore the highlighted cells): In column W, the lowest score will be ranked 1, so with row 6 being 59, it get's 1...

Hello everyone, I have a spreadsheet with employee data that contains a formula that identifies instances of consecutive weeks worked. There is an IF statement with a true value of "Yes" when consecutive weeks are identified. As each row identifies a work week, most employees have multiple rows...