C
CP
I need help with a project after an earlier response to a simple question.
I now use a marker to total qty in a column (=SUMIF($H6:$H30,"Y",D6
30)
I want to take this further by making a form on sheet1 that totals columns
from various sheets.
1) Mark a row on any sheet and then transfer the whole row to sheet1.
2) Add up the new columns produced in sheet1
I think the formula will work the same for the second part, but transfering
the rows will cause me a problem. Also is this the simplest way to do this,
I imagine this as trying to produce an order from a variety of sheets?
Many thanks
I now use a marker to total qty in a column (=SUMIF($H6:$H30,"Y",D6
30)I want to take this further by making a form on sheet1 that totals columns
from various sheets.
1) Mark a row on any sheet and then transfer the whole row to sheet1.
2) Add up the new columns produced in sheet1
I think the formula will work the same for the second part, but transfering
the rows will cause me a problem. Also is this the simplest way to do this,
I imagine this as trying to produce an order from a variety of sheets?
Many thanks