Hello Everybody,
Required:
I want 2 formulas:
1-I want a formula to calculate hours for every material in each day from "Data" sheet
2-I want a formula to calculate hours for every truck in each day from "Data" sheet
Find the attachment
I wish you help me
Last edited by leprince2007; 12-21-2016 at 05:45 AM.
B4 formula, range marked in red should be changed for each column
Formula:
Please Login or Register to view this content.
B15 formula
Formula:Please Login or Register to view this content.
Thank you Mr. kasan for your help.But there are some marks in your answer:Originally Posted by kasan
B4 formula, range marked in red should be changed for each column
Formula:Please Login or Register to view this content.
B15 formula
Formula:Please Login or Register to view this content.
1-your First formula:
You say I should change the sum range but,I want only formula only for the whole table.
2- your second formula:
I need a formula that don`t depend on any other calculations"totals"
Please help me
Last edited by leprince2007; 12-21-2016 at 07:44 AM.
Up..................Up...................Up
b4b15
Please Login or Register to view this content.Try this and copy acrossPlease Login or Register to view this content.
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Well done thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks