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

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

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

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