D
DG
I have two sheets with data on them.
Sheet two contains item numbers and monthly usage:
Item Usage Month
ABC 8 1
ABC 0 2
ABC 2 3
DEF 5 1
DEF 2 2
DEF 1 3
Sheet 1 contains the item numbers and I want to add two columns Avg and
Total. Is there a function that I can put on sheet one to total the usage
and another to average the usage from sheet 2?
Dan
Sheet two contains item numbers and monthly usage:
Item Usage Month
ABC 8 1
ABC 0 2
ABC 2 3
DEF 5 1
DEF 2 2
DEF 1 3
Sheet 1 contains the item numbers and I want to add two columns Avg and
Total. Is there a function that I can put on sheet one to total the usage
and another to average the usage from sheet 2?
Dan