Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Filter Multiple Columns on Multiple Criteria and count the last co

I have tried Macros and VBA and can get nothing to work without having to
perfoem part of the process manually.

Data:
A B C D
1 - Issued 4140 x
2 A Reject 4150 y
3 B Released SP z
4 - Issued 4140 x
5 - Reject SP w

Logic:
If A = -
and if B = Issued
and if C = 4140
then Count D

Answer = 2

Can someone help.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 747
Default Filter Multiple Columns on Multiple Criteria and count the lastco

try this

=SUMPRODUCT((A2:A10="-")*(B2:B10="issued")*(C2:C10=4140))


LBitler wrote:

I have tried Macros and VBA and can get nothing to work without having to
perfoem part of the process manually.

Data:
A B C D
1 - Issued 4140 x
2 A Reject 4150 y
3 B Released SP z
4 - Issued 4140 x
5 - Reject SP w

Logic:
If A = -
and if B = Issued
and if C = 4140
then Count D

Answer = 2

Can someone help.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default Filter Multiple Columns on Multiple Criteria and count the last co

Hi,

In 2007 you can use the following formula

=COUNTIFS(A2:A10,"-",B2:B10,"issued",C2:C10,4140)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"LBitler" wrote:

I have tried Macros and VBA and can get nothing to work without having to
perfoem part of the process manually.

Data:
A B C D
1 - Issued 4140 x
2 A Reject 4150 y
3 B Released SP z
4 - Issued 4140 x
5 - Reject SP w

Logic:
If A = -
and if B = Issued
and if C = 4140
then Count D

Answer = 2

Can someone help.

Reply
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 across multiple columns, using specific criteria MMcQ Excel Discussion (Misc queries) 9 August 27th 09 05:43 AM
To count the data using multiple criteria in multiple columns Rajesh New Users to Excel 5 December 15th 08 05:07 PM
Count multiple cells against multiple criteria in an Excel spreads EricB Excel Worksheet Functions 7 June 3rd 08 09:09 PM
How can I count items in multiple columns with different criteria. ChileRed Excel Worksheet Functions 0 March 21st 06 08:15 PM
Sum Count of Single Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 9 July 14th 05 10:01 PM


All times are GMT +1. The time now is 11:54 AM.

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

About Us

"It's about Microsoft Excel"