السلام عليكم دكتور
لوسمحت ممكن مساعدتك بطريقة ممتازة لربط الخلايا المتفرقة من صفحة كاملة بملف
مع ملف ثاني بالعمود C3
بحيث لي بيانات بشكل يومي
وعندما تدخل هذه البيانات بملف الاول
يخرج ينتج اجمالي
اشتي هذا الجمالي ينتقل للملف الثاني بالعمود C3 حسب التاريخ التسلسلي
Dear
محمد البني,
Thanks for reaching us. I understand that you want to link cells from a full page in a file and calculate the total value in column
C of another file for corresponding dates.
To demonstrate this problem, I have taken the following dataset in
Sheet2 of
Book1 workbook. It contains a date and corresponding 7 values for which I will calculate the total value. I will enter new sequential dates and corresponding values here as well.
In another workbook named
Book3, I have the following dataset where I have sequential dates. I will use a formula to calculate the total values whenever a date and corresponding values are entered in
Book1.
For that, insert the following formula in cell
C3 of the data range in
Book3 >> copy the formula to below cells using the
Fill Handle tool.
=IF([Book1]Sheet2!B13<>"",SUM([Book1]Sheet2!C13:I13),"")
Now, enter today’s date and corresponding values in
Sheet2 of
Book1.
The required output i.e. total value will automatically appear in the
Book3 workbook.
I hope this will provide you with an idea of how to solve your problem. To get the exact solution, please share the corresponding workbooks. Let us know your feedback.
Regards,
Seemanto Saha
ExcelDemy