Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Function
Ok I need help. I have a spreadsheet with two worksheets. It's a general
ledger and I have the number 5000 set up for advertising. When I go to itemize the advertising I want to use say 5100 for Pay Per Click, 5200 flyers, ect. I have one worksheet that adds the total of my expenses (advertising, supplies, ect), and one has them itemized (Flyers, Pay Per Click, Paper, Ect.) What I need is a formula that will pick up a range of numbers, ei 5000 through 5999, in the itemized worksheet and include them in my total for Advertising (5000) on my worksheet with the totals. The itemized colum will have numbers ranging from 1000-15999(or more) that will represent all my expenses from advertising to ultilties. Any help? I need something like {=if(itemized expense ranges from 5000-5999)then include it in the total for adversting (5000)} I just don't know how to look and include a range of numbers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |