LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Count multiple criteria

I want to get a count based on three columns of data. In column A I have a
department code, in column B I have plan IDs, and in column C I have a flag
that indicates if this is a financial adjustment. I want to count all the
plan IDs by department code where it is NOT a financial adjustment(or
conversely, where it says "Current").

A B C
004 Plan1 Adj
004 Plan1 Current

After reading many of the posts on this forum, I've been trying to get
SUMPRODUCT to work. This is what I've written so far:

=SUMPRODUCT(--(A$13:A$15000="004"),--(B$13:B$15000="PLAN1"),--(C$13:C$15000="Current"))

I should get a count of 10, but it returns 0 not matter how I tweak it.
What am I doing wrong?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNT WITH MULTIPLE CRITERIA Greg C Excel Worksheet Functions 8 February 7th 07 09:07 PM
Count Multiple Criteria Brian Excel Worksheet Functions 2 February 27th 06 02:44 PM
COUNT or SUM with multiple criteria Teri Excel Worksheet Functions 7 January 26th 06 05:07 PM
Multiple Count Criteria Reggie Mitchell Excel Worksheet Functions 1 December 14th 05 09:47 PM
I need to count while using multiple criteria Larry Excel Worksheet Functions 1 July 21st 05 04:56 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"