| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 Answer 2 Can someone help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 Answer 2 Can someone help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| Count occurrents based on criteria in different column | Excel Worksheet Functions | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
Hybrid Mode
