I am trying to create a spread sheet that will refresh with data and still give me what i want via formula. I struggled for hours trying to figure it out, hopefully one of you will know a way for me to accomplish this.
on one page (page2) i have self refreshing data where i have established a function of # of days an invoice is outstanding. (invoice by invoice for each vendor)
on another page is a vendor listing with an extended weekly budget (horizontally) i would like to lookup the vendor on this budget page and go to the other page of vendor invoices and summ all of the invoices that fit the criterial >x days. i can't get both formulas to work
here is the general layout
page 1
1) vender codes 2)week a 3)week b...
page 2
1) vender code 2)invoice 3)days 4)amount
1b) vender code (same or different)....
the best i could come up with was something like if(vlookup,page1vendercode, form page 2 vendorcode to amount,column 3)days, false)>35,sumif,page2 daystoamount,days>35,amount)
all this did was give me a yes if the vender had an invoice that was greater than 35 and summing every invoice greater than 35. I am trying to isolate only those invoices from that vendor that are over 35 and sum them.
thank you.
kevin
on one page (page2) i have self refreshing data where i have established a function of # of days an invoice is outstanding. (invoice by invoice for each vendor)
on another page is a vendor listing with an extended weekly budget (horizontally) i would like to lookup the vendor on this budget page and go to the other page of vendor invoices and summ all of the invoices that fit the criterial >x days. i can't get both formulas to work
here is the general layout
page 1
1) vender codes 2)week a 3)week b...
page 2
1) vender code 2)invoice 3)days 4)amount
1b) vender code (same or different)....
the best i could come up with was something like if(vlookup,page1vendercode, form page 2 vendorcode to amount,column 3)days, false)>35,sumif,page2 daystoamount,days>35,amount)
all this did was give me a yes if the vender had an invoice that was greater than 35 and summing every invoice greater than 35. I am trying to isolate only those invoices from that vendor that are over 35 and sum them.
thank you.
kevin
