Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 17th, 2013, 05:24 AM
Registered User
 
Join Date: Jan 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default countifs ??

Hi All,

Im new to excel and i would appreciate a small bit of help with this formula

im trying to count up two range to see if theres the value that i want in each range and if so and if its true then the answer is one or two etc...


=COUNTIFS('Vehicle Details'!C1:'Vehicle Details'!B1000,"PSV",'RELEASE INFORMATION'!C6:'RELEASE INFORMATION'!C1000,“OUT”)

i seem to be getting the answer unrecognized text

thanks for any help

duggie66
 
Old February 15th, 2013, 06:17 AM
Registered User
 
Join Date: Feb 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Countif error

Hi duggie66,

it's the different amount of rows and columns in the 2 Criteria Ranges that causes the error message.

Have a look at the Help page for this function. It says:

"Important Each additional range must have the same number of rows and columns as the criteria_range1 argument"

Hope this helps
Dieter









Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.