Copying cells if criteria is met

Closed
IanHeradien Posts 1 Registration date Monday 23 November 2015 Status Member Last seen 23 November 2015 - 23 Nov 2015 à 03:38
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Nov 2015 à 21:19
Hello,


I have multiple sheets with sheet 1 as the main sheet for entering data.
A cell for entering a order number
Cells for entering invoice no.'s for each store.
(Which coppies to the rest of the sheets. The above I've figured out with using: =IF(Sheet1!B3="","",Sheet1!B3).
but now I need to know how add total boxes into the main sheet and it automatically adds the number of boxes into the other sheets.

Please would be thankfullgreatly
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
24 Nov 2015 à 21:19
Not 100% sure exactly what you asked, but would not sum formula work for you