Sum of wages for the year with varying start dates

1. Sum of wages for the year with varying start dates

I have a column of months (A) and a column of wages (B) corresponding to the start month of new recruits and their wage.

How do I sum up the total for the year ?

Example:
Start date:Jan in Column A, Wage 100 in Column B
Start date:Oct in Column A, Wage 150 in Column B

That would equal a total wage cost in the year of (100*12)+(150*3)=1650

I cant seem to work out a formula. My months come from a dropdown list, wages are whatever the user types into the cell next to the dropdown list of month.

Is that clear, or should i give up for Friday ?

2. Hi Ainsley,

Can you attach a sample excel file?

3. Example

Here is the example. Cheers

4. Hi Ainsley,

Try this formula.

``Please Login or Register  to view this content.``
See the attached xl file for the example. In sheet list of start dates, i added a column, i.e. Jan = 12, Feb = 11 and so on...

5. Ah ha, I see, that works well using the Index function.

Thanks for that, have a good weekend.

6. Hi Ainsley,

Attached file above.

I'm glad it worked for you.

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