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
=IF(IS
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
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 grou