Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if < on one tab - want total on a summary sheet
I am trying to pull a summary sheet together for data I have exported to excel.
This is for a budget report. I want to show all the committed dollar amounts in the codes of the 200's. I will repeat on a second line for 300's etc. If column F data is greater than or less than (say 200 / 299) I'd like the grand total of the dollar amount from column N Tabs = MP07-04 Sort (export data information) Col F name - Account Number Cold N Name - Commit Amt I am pulling into tab Budget Reconcile. Thank you! New User |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary Sheet - Total Multiple Sheets | Excel Discussion (Misc queries) | |||
Summing related cell values and returning total to summary | Excel Discussion (Misc queries) | |||
General summary total by item | Excel Worksheet Functions | |||
Summary total from another worksheet? | Excel Worksheet Functions | |||
Show one total summary but have drill down to detail | Excel Discussion (Misc queries) |