Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identify the row with specific criteria
Hi
I have a database where column A - D contain country, product, etc, column E - Q contain Jan - Dec and full year volume while column E contain Jan - Dec and full year sales value. Product has sales in particular month should also has sales volume in the same month in principle. Since volume and sales are derived from different sources, some products in particular months may contain volume but no sales value. I established conditional format, e.g. =and(e2<0, S=0) in the sales columns to identify those cells, however, I have to review all (12) columns to identify those products. How can I put a formula (in cell or conditional format) to identify those products which contain whatever month has volume but no sales in the same month. Besides, I often use "sumproduct" (or "sum(if" ) to sum up in multi-conditional circumstances, what is the purpose to put -- in sumproduct formula, could you illustrate by an example. Thank you. Billy L |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify address of cell containing specific data | Excel Discussion (Misc queries) | |||
formula to identify specific cells | Excel Discussion (Misc queries) | |||
search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
How do I identify Filter criteria or variable graph title? | Excel Discussion (Misc queries) | |||
Identify missing criteria | Excel Worksheet Functions |