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.

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.

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.