For the best help attach a sample workbook to your post
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: countifs

Search: Replies Views Search took 0.00 seconds.

[SOLVED] COUNTIFS with multiple criteria across non-contiguous ranges

Started by 77highland‎, 01-23-2025 08:01 PM
- 3
- 251
Last Post By:

Last Post: 01-27-2025 08:14 AM

by Gregb11

Forum:
Excel Formulas & Functions
COUNTIFS Missing Critera

Started by MISSYELLOW‎, 10-15-2024 10:16 PM
- 3
- 181
Last Post By:

Last Post: 10-16-2024 12:05 AM

by AliGW

Forum:
Excel Formulas & Functions
[SOLVED] SUMIFS error on criteria range with leading zero text

Started by SorenThadePetersen‎, 10-01-2024 05:06 AM
- 13
- 397
Last Post By:

Last Post: 10-02-2024 09:40 AM

by wk9128

Forum:
Excel Formulas & Functions
[SOLVED] 2 Criteria to Determine What Data Set to Use During VLOOKUP

Started by xDarkDeadpool‎, 07-25-2024 05:20 PM
- 10
- 398
Last Post By:

Last Post: 07-29-2024 10:14 AM

by wk9128

Forum:
Excel Formulas & Functions
[SOLVED] Count function to count number of clients who received service in a given month

Started by rpederson‎, 05-09-2024 10:04 AM
- 11
- 353
Last Post By:

Last Post: 05-09-2024 12:40 PM

by etaf

Forum:
Excel Formulas & Functions
Count cells containing keywords with multiple criteria

Started by Kailef‎, 04-13-2024 10:36 PM
- 7
- 288
Last Post By:

Last Post: 04-14-2024 02:31 AM

by CARACALLA

Forum:
Excel Formulas & Functions
[SOLVED] rank order by up to 4 progressive criteria

Started by geemacmcm‎, 03-28-2024 08:07 AM
- 6
- 271
Last Post By:

Last Post: 03-30-2024 12:57 PM

by AliGW

Forum:
Excel Formulas & Functions
COUNTIFS is not able to solve the task

Started by vilipec‎, 03-23-2024 06:22 AM
- 17
- 451
Last Post By:

Last Post: 03-30-2024 05:40 AM

by AliGW

Forum:
Excel Formulas & Functions
[SOLVED] countif based on certain month due date

Started by johan58‎, 03-19-2024 09:42 AM
- 6
- 213
Last Post By:

Last Post: 03-19-2024 10:15 AM

by Fluff13

Forum:
Excel Formulas & Functions
COUNTIFS based on text and date

Started by Axildoof‎, 02-06-2024 11:46 AM
- 3
- 281
Last Post By:

Last Post: 02-06-2024 01:11 PM

by Pete_UK

Forum:
Excel Formulas & Functions
[SOLVED] Countifs not working with 2 criteria

Started by sickreto‎, 01-24-2024 10:17 AM
- 4
- 256
Last Post By:

Last Post: 01-24-2024 11:32 AM

by Fluff13

Forum:
Excel General
Countifs with multiple named ranges as criteria

Started by mmytb‎, 01-11-2024 09:00 AM
- 3
- 422
Last Post By:

Last Post: 01-11-2024 09:26 AM

by Fluff13

Forum:
Excel Formulas & Functions
[SOLVED] Dates - easy way click and drag for count if?

Started by researchguru‎, 11-13-2023 02:53 AM
- 11
- 481
Last Post By:

Last Post: 11-14-2023 02:12 AM

by AliGW

Forum:
Excel Formulas & Functions
[SOLVED] COUNTIFS matching a range

Started by bahalzamon‎, 10-18-2023 07:17 PM
- 3
- 449
Last Post By:

Last Post: 10-19-2023 01:50 PM

by bahalzamon

Forum:
Excel General
[SOLVED] Converting a complex COUNTIFS formula into an equvalent (older) COUNTIF formula

Started by Robert Chudek‎, 10-04-2023 05:09 PM
- 8
- 501
Last Post By:

Last Post: 10-08-2023 09:14 PM

by Robert Chudek

Forum:
Excel Formulas & Functions
[SOLVED] Using COUNTIF with VLOOKUP to return # of results for a given date

Started by BelleSprout‎, 09-25-2023 01:33 PM
- 5
- 483
Last Post By:

Last Post: 09-25-2023 03:04 PM

by BadlySpelledBuoy

Forum:
Excel Formulas & Functions
Please help fix my ChatGPT formulas. Growth rate since January 2022.

Started by NHS Excel Guy‎, 09-22-2023 07:50 AM
- 10
- 486
Last Post By:

Last Post: 09-22-2023 02:14 PM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
[SOLVED] Adding multiple criteria to COUNTIFS (don't count duplicates)

Started by RookA1‎, 08-25-2023 02:39 PM
- 8
- 2,368
Last Post By:

Last Post: 08-29-2023 08:49 PM

by Gregb11

Forum:
Excel Formulas & Functions
Threshold Tracking

Started by ghummel77‎, 08-17-2023 03:40 PM
- 8
- 598
Last Post By:

Last Post: 01-29-2024 11:48 AM

by ghummel77

Forum:
Excel General
[SOLVED] Count # employees working during a certain time

Started by Ur_uncle‎, 07-22-2023 07:51 PM
- 3
- 392
Last Post By:

Last Post: 07-22-2023 10:42 PM

by windknife

Forum:
Excel Formulas & Functions
SUMIFS formula returns value 0

Started by parthmaniar‎, 07-16-2023 07:20 AM
- 6
- 474
Last Post By:

Last Post: 07-28-2023 09:18 AM

by parthmaniar

Forum:
Excel Formulas & Functions
[SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns

Started by 77highland‎, 06-09-2023 04:48 PM
- 3
- 530
Last Post By:

Last Post: 06-09-2023 05:19 PM

by 77highland

Forum:
Excel Formulas & Functions
[SOLVED] COUNTIFS using OR logic on multiple fields

Started by MikeMacM‎, 05-11-2023 12:08 PM
- 4
- 427
Last Post By:

Last Post: 05-11-2023 01:17 PM

by MikeMacM

Forum:
Excel Programming / VBA / Macros
[SOLVED] Extract data by month and year

Started by Kekeken‎, 05-03-2023 11:55 AM
- 8
- 541
Last Post By:

Last Post: 05-05-2023 01:13 PM

by Kekeken

Forum:
Excel Formulas & Functions
[SOLVED] Countifs number of transactions within month and year and match specific location

Started by MAJID1479‎, 04-08-2023 05:47 AM
- 1
- 403
Last Post By:

Last Post: 04-08-2023 12:07 PM

by alansidman

Forum:
Excel Formulas & Functions
[SOLVED] Countifs number of transactions within month and year and match specific location

Started by MAJID1479‎, 04-08-2023 05:12 AM
- 7
- 528
Last Post By:

Last Post: 04-08-2023 12:07 PM

by MAJID1479

Forum:
Excel Formulas & Functions
COUNTIFS criteria over multiple columns - #VALUE error

Started by Armitage2k‎, 04-02-2023 03:05 AM
- 4
- 396
Last Post By:

Last Post: 04-02-2023 04:49 AM

by CARACALLA

Forum:
Excel Formulas & Functions
COUNTIFS Data Range Criterion

Started by alext23‎, 03-21-2023 11:07 AM
- 3
- 499
Last Post By:

Last Post: 04-05-2023 03:10 AM

by Glenn Kennedy

Forum:
Excel Formulas & Functions
[SOLVED] COUNTTFS depending on criteria

Started by rayted‎, 03-09-2023 05:31 AM
- 5
- 421
Last Post By:

Last Post: 03-09-2023 06:09 AM

by TMS

Forum:
Excel Formulas & Functions
Trying to simplify a SORT(UNIQUE(FILTER(xxxxx))) , a COUNTIFS, and an INDEX(SORT(xxxx))

Started by Larry1957‎, 01-12-2023 08:32 PM
- 6
- 836
Last Post By:

Last Post: 01-13-2023 04:42 PM

by TMS

Forum:
Excel Formulas & Functions
Logic within Countif/Countifs

Started by Shirtbeast‎, 01-05-2023 04:49 AM
- 2
- 406
Last Post By:

Last Post: 01-05-2023 05:29 AM

by JohnTopley

Forum:
Excel General
conditional format with conditons

Started by excel wannabe pp‎, 01-05-2023 12:55 AM
- 10
- 505
Last Post By:

Last Post: 01-05-2023 02:56 AM

by HansDouwe

Forum:
Excel Formulas & Functions
Countifs but exclude a particular reference

Started by lisa.pugh‎, 12-15-2022 08:19 PM
- 4
- 395
Last Post By:

Last Post: 12-16-2022 05:32 PM

by jindon

Forum:
Excel Programming / VBA / Macros
[SOLVED] COUNTIFS - Where Closed date is less than or equal to Open date +7

Started by JasonMS‎, 12-05-2022 10:10 AM
- 5
- 634
Last Post By:

Last Post: 12-05-2022 09:32 PM

by josephteh

Forum:
Excel Formulas & Functions
Running count with spill range, zeroing out counts >1

Started by Marbleking‎, 12-01-2022 04:06 AM
- 6
- 449
Last Post By:

Last Post: 12-01-2022 05:38 AM

by kvsrinivasamurthy

Forum:
Excel Formulas & Functions

Results 1 to 35 of 459

Search: Replies Views Search took 0.00 seconds.

[SOLVED] COUNTIFS with multiple criteria across non-contiguous ranges

[SOLVED] SUMIFS error on criteria range with leading zero text

[SOLVED] 2 Criteria to Determine What Data Set to Use During VLOOKUP

[SOLVED] Count function to count number of clients who received service in a given month

[SOLVED] rank order by up to 4 progressive criteria

[SOLVED] countif based on certain month due date

[SOLVED] Countifs not working with 2 criteria

[SOLVED] Dates - easy way click and drag for count if?

[SOLVED] COUNTIFS matching a range

[SOLVED] Converting a complex COUNTIFS formula into an equvalent (older) COUNTIF formula

[SOLVED] Using COUNTIF with VLOOKUP to return # of results for a given date

[SOLVED] Adding multiple criteria to COUNTIFS (don't count duplicates)

[SOLVED] Count # employees working during a certain time

[SOLVED] Sumproduct Count multiple criteria with range over multiple rows and columns

[SOLVED] COUNTIFS using OR logic on multiple fields

[SOLVED] Extract data by month and year

[SOLVED] Countifs number of transactions within month and year and match specific location

[SOLVED] Countifs number of transactions within month and year and match specific location

[SOLVED] COUNTTFS depending on criteria

[SOLVED] COUNTIFS - Where Closed date is less than or equal to Open date +7