Dears i am anew member here and i hope i am posting in the right section
now i have a sheet where there is a name column and a number column and start month column and duration column and jan to dec column
i need a formula where it takes the volume divide it by the duration and then it only on the month where it matches the durations .
sample sheet is attached , i hope you can help me
client volume start month project duration jan feb mar apr may jun jul aug sep oct nov dec
a 6000 jan 6
i added the file and manually did what i wanted it to do as an example .
thank you all in advance
Bookmarks