Dear All,
I want the sum of effort for each month in the summary sheet, please help it's urgent.
Regards
Dear All,
I want the sum of effort for each month in the summary sheet, please help it's urgent.
Regards
you need an array formula
=SUM(IF(MONTH(Efforts!K6:FE6)=1,Efforts!K7:FE7,0)) confirmed with ctrl+shift+enter will sum all efforts in january for row 7
you would have to do this for each month then sum those based on catogary in col B i made a start for you by using some helper column to give totals required on efforts_summary.
note that you can only have this for one complete 12 month period as the formula would not differentiate say between jan 2008 and jan 2009
I am not able to understand your file and what help you require in the file?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks