Countif multiple same range

		Microsoft Office Forums > Microsoft Excel > Excel
Countif multiple same range

#10

03-30-2019, 08:44 AM

bosco_yip

Windows 10 Countif multiple same range

Office 2016

Novice

Join Date: Feb 2019

Location: Singapore

Posts: 7

Quote:

Originally Posted by Greggey1

That's very close. The only thing is if someone who enters a number not beginning with 9 I don't want it to count. Thanks for the help.

Then, the formula changed to

=SUMPRODUCT(ISNUMBER(1/(0+LEFT(B5:B14)=9))*(LEN(B5:B14)-LEN(SUBSTITUTE(B5:B14,"/",""))+1))

Regards
Bosco

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with multiple criteria	Marcia	Excel	5	02-17-2019 08:16 AM
Use countif across multiple tabs for a column	marconexcel	Excel	6	02-21-2017 05:38 AM
Sumif with multiple sum range	Haha88	Excel	6	10-29-2015 03:26 AM
multiple criteria and within a range?	hhppyy	Excel	1	07-17-2015 08:17 AM
Using range object to work with multiple columns	kjworduser	Word VBA	1	11-01-2013 03:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 AM.