Forum Discussion
Formula creation help
Hi, Is anyone able to help me create a formula in Excel (Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20180) 32-bit) that provides the total number of hours to assign t...
mollfrog Perhaps like in the attached file. Rows 5,7 and 9 show the formulae used in the cells on row 3 above each of them. For information only.
Riny_van_Eekelen Thank you, but I gave you the wrong references, sorry! The table looks like the attached.
The total in V6 should remain blank until anything is entered into V2-5.
mollfrog You did not attach "the table".
Riny_van_Eekelen sorry, try now
mollfrog Thanks for that. It doesn't really matter where you put the formulae on the grid, as long as the calculations are done correctly. I took my original file and moved it all around in the places where you want to have it. And then I tweaked it a bit to create an all-in-one formula in V6.
File attached.
