Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
variation on SUMIF funciton
I have a spreadsheet of the form:
Household Sales 1 1 1 0 1 1 2 0 2 0 3 1 3 1 3 1 etc, etc, I am trying to find the total number of sales for each specific household and as my spreadsheet is very large i'd prefer not to do it manually. I have tried using a SUMIF function, but I can't manipulate the 'criteria' section of the function such that I can set it equal to the value of a specific cell - I can only seem to manually enter in the specific household identity number. Is there anyway to alter the SUMIF function (or indeed do it a different way) that will allow me to do this calculation quickly. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with nested funciton using vlookup | Excel Discussion (Misc queries) | |||
Variation from the mean? | Charts and Charting in Excel | |||
SUMIF variation? | Excel Worksheet Functions | |||
RANK Funciton | Excel Worksheet Functions | |||
variation on countif? | Excel Worksheet Functions |