Based on Mulipple Criteria acrossed Column count last column

  • Thread starter Thread starter LBitler
  • Start date Start date
L

LBitler

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

Answer 2

Can someone help
 
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.
 
Back
Top