| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Totals for month if 2 conditions are met
Hi,
Wonder if anyone could put me on the correct track? I need to show the totals for the following: (if target_name_sheet1=target_name_this sheet)and(if actual_month_sheet1=4)then total actual_value_sheet1for month 4. and place in cell E6 this sheet. (hope you can follow that) I think that it should be a SUMPRODUCT function but not sure how to put it together. -- any help gratefully received thanks carrach |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Totals Lookup by month and year | Excel Worksheet Functions | |||
| Sum Totals/Different Conditions | Excel Discussion (Misc queries) | |||
| Grouping totals together by month per customer | Excel Discussion (Misc queries) | |||
| keep totals from month to month? | Excel Worksheet Functions | |||
| running totals in a macro for each month | Excel Worksheet Functions | |||
Threaded Mode
