View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BT[_2_] BT[_2_] is offline
external usenet poster
 
Posts: 22
Default 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