countif - Search Results - Excel Help Forum

Count number of nonblank cells in column B, C if value in column D = 1 (or 2)

Started by AdamDrover‎, 07-04-2017 06:49 AM

12

782

Last Post By:: Last Post: 07-04-2017 08:31 AM; by AdamDrover

Forum:
Excel Formulas & Functions

Placing character under a month and year when the month falls between two dates

Started by gagento‎, 07-02-2017 07:58 PM

1

502

Last Post By:: Last Post: 07-02-2017 08:02 PM; by gagento

Forum:
Excel Formulas & Functions

[SOLVED] COUNTIFS with Multiple Text Criteria in Same Criteria Range

Started by xl2016‎, 06-17-2017 05:47 PM

5

790

Last Post By:: Last Post: 06-18-2017 05:00 AM; by Richard Buttrey

Forum:
Excel General

Count how many times a date in column G exceeds respective Row in Column A

Started by tangerine7199‎, 06-14-2017 03:43 PM

1

534

Last Post By:: Last Post: 06-14-2017 04:44 PM; by CAntosh

Forum:
Excel - New Users/Basics

Need help with my countif formula, bit off more than i can chew

Started by ahalliwell‎, 06-09-2017 05:33 AM

2

353

Last Post By:: Last Post: 06-09-2017 05:47 AM; by ahalliwell

Forum:
Excel Formulas & Functions

How can I make =IF(COUNTIF(B$2:B2,0)>=1,0,COUNTIF(A$2:A2,0)) workwhen copying it further?

Started by Dussy‎, 05-26-2017 07:22 AM

8

2,226

Last Post By:: Last Post: 05-27-2017 07:04 AM; by JohnTopley

Forum:
Excel Formulas & Functions

[SOLVED] Using Sumproduct in place of CountIf

Started by lbickford‎, 05-10-2017 03:21 PM

2

461

Last Post By:: Last Post: 05-10-2017 03:42 PM; by lbickford

Forum:
Excel Formulas & Functions

[SOLVED] COUNTIF - Values match

Started by zudecke‎, 05-10-2017 08:39 AM

4

504

Last Post By:: Last Post: 05-10-2017 09:37 AM; by LukeGilfoyle

Forum:
Excel General

[SOLVED] COUNTIF on row and column criteria

Started by Musiclover119‎, 05-10-2017 02:51 AM

15

8,534

Last Post By:: Last Post: 06-26-2018 04:51 AM; by atul7600

Forum:
Excel Formulas & Functions

New to advanced XL features, and need a relatively simple (I think?) formula

Started by ladiletta‎, 04-24-2017 09:12 PM

2

388

Last Post By:: Last Post: 04-24-2017 09:44 PM; by ladiletta

Forum:
Excel Formulas & Functions

[SOLVED] How to count a value in different sheets?

Started by ofarooq‎, 04-17-2017 02:19 PM

5

658

Last Post By:: Last Post: 04-17-2017 03:55 PM; by ofarooq

Forum:
Excel Formulas & Functions

COUNTIF NESTED IN IF Function

Started by matthew.ng.zh‎, 04-16-2017 09:59 AM

4

1,055

Last Post By:: Last Post: 04-16-2017 10:41 AM; by matthew.ng.zh

Forum:
Excel Formulas & Functions

Countif based on the title in my first row.

Started by liamfrancis2013‎, 04-03-2017 08:12 AM

2

652

Last Post By:: Last Post: 04-03-2017 08:32 AM; by canapone

Forum:
Excel Formulas & Functions

countif?

Started by matty0511‎, 04-02-2017 10:13 PM

18

1,003

Last Post By:: Last Post: 04-05-2017 11:23 AM; by JeteMc

Forum:
Excel Formulas & Functions

Countif(s) automatic recognition of a name

Started by JaimeP‎, 03-24-2017 06:17 AM

6

409

Last Post By:: Last Post: 04-03-2017 03:04 AM; by JaimeP

Forum:
Excel Formulas & Functions

[SOLVED] COUNTIF value in column A is <, =, or < corresponding value in same row, column B

Started by KDSearle‎, 03-21-2017 03:27 PM

5

552

Last Post By:: Last Post: 03-21-2017 04:10 PM; by TMS

Forum:
Excel Formulas & Functions

VBA: Multiple Worksheet_Change Macros + COUNTIF

Started by hysterical.useless‎, 03-17-2017 02:33 PM

36

1,569

Last Post By:: Last Post: 05-26-2017 06:48 PM; by hysterical.useless

Forum:
Excel Programming / VBA / Macros

[SOLVED] Count of bad units out for warranty repair.

Started by israelalvarado‎, 03-07-2017 02:38 PM

4

578

Last Post By:: Last Post: 03-07-2017 09:04 PM; by guru008

Forum:
Excel General

[SOLVED] Total count of radios on second worksheet.

Started by israelalvarado‎, 03-01-2017 07:33 PM

2

508

Last Post By:: Last Post: 03-02-2017 02:05 PM; by israelalvarado

Forum:
Excel General

[SOLVED] Count challenge request please.

Started by israelalvarado‎, 03-01-2017 04:50 PM

1

469

Last Post By:: Last Post: 03-01-2017 05:06 PM; by cytop

Forum:
Excel General

[SOLVED] Total count of radios in for repair (challenge)

Started by israelalvarado‎, 03-01-2017 02:28 PM

5

569

Last Post By:: Last Post: 03-01-2017 05:56 PM; by israelalvarado

Forum:
Excel Formulas & Functions

SUMPRODUCT or SUMIF Formula Help Please

Started by reddaze‎, 03-01-2017 08:00 AM

6

443

Last Post By:: Last Post: 03-01-2017 08:27 AM; by Phuocam

Forum:
Excel Formulas & Functions

[SOLVED] Calculating info in a column based on a "greater than" date & info in another column

Started by fpm2002‎, 02-26-2017 04:34 AM

countif, date as criteria, greater than, sumproduct

10

846

Last Post By:: Last Post: 03-06-2017 12:58 AM; by fpm2002

Forum:
Excel Formulas & Functions

[SOLVED] count no of days with condition

Started by sandeshbhavsar‎, 02-24-2017 05:04 AM

count, countif, days, days between steps

8

812

Last Post By:: Last Post: 02-24-2017 05:39 AM; by bebo021999

Forum:
Excel Formulas & Functions

[SOLVED] Count Distinct and SUMIF to find unique text values

Started by hilton426‎, 02-23-2017 05:58 AM

array, countif, distinct values, string, sumif

3

3,137

Last Post By:: Last Post: 02-23-2017 08:18 AM; by hilton426

Forum:
Excel Formulas & Functions

[SOLVED] Count how many rows contain a number of matches with another

Started by Ichigo12‎, 02-17-2017 02:38 PM

5

530

Last Post By:: Last Post: 02-19-2017 03:49 PM; by FlameRetired

Forum:
Excel Formulas & Functions

[SOLVED] INDEX MATCH MATCH but with COUNTIFS??

Started by hilton426‎, 02-13-2017 08:01 AM

2

632

Last Post By:: Last Post: 02-13-2017 09:47 AM; by hilton426

Forum:
Excel Formulas & Functions

[SOLVED] Excel Lookup/COUNTIF/SUMIF Questions

Started by chrisbeaudet‎, 02-08-2017 10:43 PM

countif, function, sumif, vlookup, wedding

2

732

Last Post By:: Last Post: 02-08-2017 10:58 PM; by chrisbeaudet

Forum:
Excel Formulas & Functions

[SOLVED] AutoFill CountIF Formula

Started by acefondu‎, 02-08-2017 02:11 PM

5

1,798

Last Post By:: Last Post: 02-08-2017 03:52 PM; by JBeaucaire

Forum:
Excel Formulas & Functions

Duplicate Cells' Summed Total

Started by DemRulesDoe‎, 02-01-2017 05:45 PM

4

927

Last Post By:: Last Post: 02-01-2017 08:54 PM; by Tony Valko

Forum:
Excel General

[SOLVED] String COUNTIF that does not count Strikethroughs?

Started by DoNoEvil‎, 02-01-2017 02:05 PM

3

988

Last Post By:: Last Post: 02-13-2017 03:35 PM; by DoNoEvil

Forum:
Excel General

Need to export duplicate values, excel keeps crashing!

Started by jviland‎, 01-30-2017 12:14 PM

countif, crashing, duplicate, extract, filter

3

4,302

Last Post By:: Last Post: 01-30-2017 02:34 PM; by CK76

Forum:
Excel General

[SOLVED] COUNTIFS with Multiple TEXT and BLANK Criteria

Started by swiftrain‎, 01-25-2017 10:05 AM

4

4,077

Last Post By:: Last Post: 01-25-2017 10:17 AM; by joris moerings

Forum:
Excel Formulas & Functions

help with holiday planner and assigning leave dates to specific years

Started by marktc19‎, 01-23-2017 09:48 AM

1

449

Last Post By:: Last Post: 01-23-2017 09:49 AM; by marktc19

Forum:
Excel Formulas & Functions

working on a holiday planner based on various holiday anniversary dates

Started by marktc19‎, 01-23-2017 09:23 AM

1

682

Last Post By:: Last Post: 01-23-2017 09:26 AM; by Tony Valko

Forum:
Excel Formulas & Functions

Search:

Search: Replies Views Search took 0.01 seconds; generated 29 minute(s) ago.

Count number of nonblank cells in column B, C if value in column D = 1 (or 2)

Placing character under a month and year when the month falls between two dates

[SOLVED] COUNTIFS with Multiple Text Criteria in Same Criteria Range

Count how many times a date in column G exceeds respective Row in Column A

Need help with my countif formula, bit off more than i can chew

How can I make =IF(COUNTIF(B$2:B2,0)>=1,0,COUNTIF(A$2:A2,0)) workwhen copying it further?

[SOLVED] Using Sumproduct in place of CountIf

[SOLVED] COUNTIF - Values match

[SOLVED] COUNTIF on row and column criteria

New to advanced XL features, and need a relatively simple (I think?) formula

[SOLVED] How to count a value in different sheets?

COUNTIF NESTED IN IF Function

Countif based on the title in my first row.

countif?

Countif(s) automatic recognition of a name

[SOLVED] COUNTIF value in column A is <, =, or < corresponding value in same row, column B

VBA: Multiple Worksheet_Change Macros + COUNTIF

[SOLVED] Count of bad units out for warranty repair.

[SOLVED] Total count of radios on second worksheet.

[SOLVED] Count challenge request please.

[SOLVED] Total count of radios in for repair (challenge)

SUMPRODUCT or SUMIF Formula Help Please

[SOLVED] Calculating info in a column based on a "greater than" date & info in another column

[SOLVED] count no of days with condition

[SOLVED] Count Distinct and SUMIF to find unique text values

[SOLVED] Count how many rows contain a number of matches with another

[SOLVED] INDEX MATCH MATCH but with COUNTIFS??

[SOLVED] Excel Lookup/COUNTIF/SUMIF Questions

[SOLVED] AutoFill CountIF Formula

Duplicate Cells' Summed Total

[SOLVED] String COUNTIF that does not count Strikethroughs?

Need to export duplicate values, excel keeps crashing!

[SOLVED] COUNTIFS with Multiple TEXT and BLANK Criteria

help with holiday planner and assigning leave dates to specific years

working on a holiday planner based on various holiday anniversary dates