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
|