Remember Me?

#1
February 12th 09, 05:52 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Feb 2009 Posts: 2
Based on Mulipple Criteria acrossed Column count last column

I have tried Macros and VBA and can not get anything to work with out
performing part of the process manually.

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

Can someone help

#2
February 12th 09, 06:58 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2008 Posts: 2,389
Based on Mulipple Criteria acrossed Column count last column

Try this:
=Sumproduct(--(a1:a5="-"),--(b1:b5="Issued"),--(c1:c5=4140))

In your example, the value of D is immaterial. If you want to check for an
"x" in D, just add it to the above.

Regards,
Fred.

"LBitler" wrote in message
...
I have tried Macros and VBA and can not get anything to work with out
performing part of the process manually.

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

Can someone help

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ccKennedy Excel Worksheet Functions 2 January 9th 09 11:26 PM ccKennedy Excel Worksheet Functions 2 January 9th 09 07:50 PM Blueagm Excel Worksheet Functions 2 August 16th 08 11:15 PM Beach Lover Excel Discussion (Misc queries) 9 February 19th 07 03:39 PM ScottPcola Excel Worksheet Functions 3 November 3rd 06 10:11 PM

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