COUNTIFS equivalent in 2003...?

blist

New Member
Joined
Mar 11, 2004
Messages
20
The following formula works as I'd like in Excel 2010.

Code:
=COUNTIFS(C:C,C2,K:K,"=J*")

What formula will return the same results when used in Excel 2003? I'm peddaling as fast as I can, and still unsuccessful after endless searching and testing for a solution. Huge thanks for any and every bit of help here!
 
Last edited:

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

RSXchin

Well-known Member
Joined
Oct 23, 2010
Messages
758
You're looking for SUMPRODUCT

I'll try and find the correct usage for it.
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
You can't use whole column references for SUMPRODUCT in 2003......and you can't use wildcards so you need a version like this

=SUMPRODUCT((C$2:C$1000=C2)*(LEFT(K$2:K$1000)="J"))

adjust ranges as required
 

RSXchin

Well-known Member
Joined
Oct 23, 2010
Messages
758
don't forget to hit CTRL+SHIFT+ENTER when you put that one in. Because it's an array formula (I think...)
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
don't forget to hit CTRL+SHIFT+ENTER when you put that one in. Because it's an array formula (I think...)

It's true that it processes array objects and it is designed to do so per default that there is in fact no need for control+shift+enter.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,143
Messages
5,599,975
Members
414,354
Latest member
Flaxarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top