if > < on one tab - want total on a summary sheet

B

BT

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
 
T

T. Valko

Try this:

=SUMPRODUCT(--('MP07-04 Sort'!F1:F100>=200),--('MP07-04
Sort'!F1:F100<=299),'MP07-04 Sort'!N1:N100)
 
B

BT

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

:

Try this: =SUMPRODUCT(--('MP07-04 Sort'!F1:F100>=200),--('MP07-04
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

total columns of one sheet on another sheet 1
Selectively Moving Data to a Summary Sheet 17
lookup? list data into summary table 6
Automatically add a column to summary sheet if another worksheet i 2
adding multiple values from matched search results 3
Populate excel sheet based on values in a separate sheet 3
Daily Totals on a summary sheet 10
I want to jump to a worksheet from a contents sheet 2

Top