# solve this sum problem

1. ## solve this sum problem

dear all,
this is varun,plz help me to solve this sum problem.this is the increment sheet & when a worker present 31 days he gets 200/- increment in his monthly salary.& when a worker present only 30 days ,he gets 100/- & if he present below 30days he gets nothing.
when I use =if(a2=31,"200",if(a2=30,"100","0")). this formula is working but problem is when i get increment it is not being sum the column of =sum(b2:b4) it shows 0.
plz help me to short out this sum problem.

thanks & best regards
varun
varunmsw05@yahoo.co.in

2. ## re: solve this sum problem

Hi,
remove the double quotes around the numbers in your formula, otherwise XL sees them as text

3. ## re: solve this sum problem

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Title edited this time

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1