Dear Team members,
I have joined the below google group which is very useful for us.
As a member in coreteam, we mostly use excel.
This group is very useful to learn advanced features of excel.
*excel-mac...@googlegroups.com.*
If you have any problem in excel, you can join and post in this
Hi,
You can use iserror() function to find out any errors.
You can use If() function to replace error values to zeroes.
use the following formula in adjucent column/row of the actual values that
you want to sum
eg. you want total the values in column C, then use this formula in column D
Hi,
Add week columns adjucent to stdt, spdt eg. week21, week22
use the IF function for each week and return 1 if the dates fall within the
week. (eg. if(stdt 127 and (spdt 156 or isblank(spdt)) ,1,0)
repeat this for each week.
then use the DATA - SUBTOTALS COMMAND to get pat wise subtotals or