Convert CountIfs to Office 2003

**ABBOV** · 03-18-2011, 07:39 AM

Hello,

I've got the following piece of vba code (thanks to Tom Hogan)

Dim MatchRange As Range
Dim IndexRange As Range
Dim AspectRange As Range
Dim ExitRange As Range
Dim AspectValue As Variant

countexit = Application.WorksheetFunction.CountIfs(AspectRange, AspectValue, ExitRange, ("*" & "Exit" & "*"))

But this is only working with Office 2007, I've learned that SUMPRODUCT can do the same, is there anyone who can convert the countifs formula for me?

Thanks in Advance.

ABBOV

**royUK** · 03-18-2011, 08:24 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

also, what exactly are you doing?

**tom.hogan** · 03-18-2011, 09:14 AM

Roy,
Here is the original post http://www.excelforum.com/excel-prog...ll-values.html

which includes the dummy worksheet. My solution works but I'm sure there is a better way to meet his requirement.

Thanks,

Tom

Thread: Convert CountIfs to Office 2003

Thread Tools

Display

Convert CountIfs to Office 2003

Re: Convert CountIfs to Office 2003

Re: Convert CountIfs to Office 2003

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions