| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif statements
Hi there
I am trying to create a report in order to calculate spends per customer which consists of two work sheets €“ The first worksheet has all the sales data as well as the sites and customer mixed in the same worksheet The second sheet need to summarize the data and need to lookup the merchandised category in column A, customer type in column B and the sites in column C all from sheet 1and enter the total value in column D in sheet 2. I know I need to use a conditional sum statement for this but not so sure how to do it, can any body help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| using sumif formula: but requiring satisfying 2 if statements | Excel Worksheet Functions | |||
| SumIf or SumProduct or If statements | Excel Worksheet Functions | |||
| Combining IF and multiple SUMIF statements, if A>0 & B is between | Excel Worksheet Functions | |||
Threaded Mode
