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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if < on one tab - want total on a summary sheet
Try this:
=SUMPRODUCT(--('MP07-04 Sort'!F1:F100=200),--('MP07-04 Sort'!F1:F100<=299),'MP07-04 Sort'!N1:N100) -- Biff Microsoft Excel MVP "BT" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if < on one tab - want total on a summary sheet
Biff,
Thank YOU! Very much. This worked. I am happy to have found this site to learn so much more with excel!! Appreciate your help! BT "T. Valko" wrote: Try this: =SUMPRODUCT(--('MP07-04 Sort'!F1:F100=200),--('MP07-04 Sort'!F1:F100<=299),'MP07-04 Sort'!N1:N100) -- Biff Microsoft Excel MVP "BT" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if < on one tab - want total on a summary sheet
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "BT" wrote in message ... Biff, Thank YOU! Very much. This worked. I am happy to have found this site to learn so much more with excel!! Appreciate your help! BT "T. Valko" wrote: Try this: =SUMPRODUCT(--('MP07-04 Sort'!F1:F100=200),--('MP07-04 Sort'!F1:F100<=299),'MP07-04 Sort'!N1:N100) -- Biff Microsoft Excel MVP "BT" wrote in message ... 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 |
Reply |
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) |