| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum data, depending on cell content
On 18 Oct, 13:39, Pete_UK wrote:
If you had a simple formula like: =A2 in cell A3 and copied this down, then whenever you had a new receipt number (let's say in A10) and entered 1234, then all the cells below it would show this. If another new receipt number had to be entered in A15, then the cells below that would show the new receipt no. So, you would only have to enter the receipt number for the first entry, over- writing the formula - saves a bit of inputting ... Hope this helps. Pete On Oct 18, 1:28 pm, Mik wrote: On 18 Oct, 13:22, Pete_UK wrote: I can't think of a way - SUMIF relies on matching data from the range in its first parameter to the contents of its second parameter, so if you had blanks in column A it would not be able to match with it. Is there a problem recording the receipt number on every row? Pete On Oct 18, 1:04 pm, Mik wrote: Thanks for your responce Pete, Is there a way of applying this without having to insert the receipt number for all transactions? Mike- Hide quoted text - - Show quoted text - No problem really, It's just that the spreadsheet has so much content that requires an input, that we are now reviewing all areas where the input could be either automated or simplified. So the less input required the better. Thanks again, Mike- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - Pete, Thanks for your help. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
| Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
| changing the colour of cells depending on the content. | Excel Discussion (Misc queries) | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
Hybrid Mode
