Countif

  • Thread starter Thread starter kje.1953
  • Start date Start date
K

kje.1953

I am trying to get a formula to work without success

I want a count for each month (Colum H) where the value is CANC (Column L)

The date is formatted as e.g. Mar-09


=SUMPRODUCT(($H$11:$H$1000=3-9)*($L$11:$L$1000=canc)) I get the result
#NAME? is it something to do with the date format?

HELP

Version 2003

kje.1953
 
kje.1953 said:
I am trying to get a formula to work without success

I want a count for each month (Colum H) where the value is CANC (Column L)

The date is formatted as e.g. Mar-09


=SUMPRODUCT(($H$11:$H$1000=3-9)*($L$11:$L$1000=canc)) I get the result
#NAME? is it something to do with the date format?

HELP

Version 2003

kje.1953

Again, wrong discussion group.

As you appear to be using a web interface, try this:

http://www.microsoft.com/communities/newsgroups/en-us/

In the tree on the left, open English, then open Office and Desktop
Applications. In the Office and Desktop Applications
subcategory, find and open the subcategory for Excel, and find a group
there for your post.
 
Back
Top