Sum where application employees diff but charge code same

**rz6657** · 10-09-2010, 01:01 AM

Excel 2007

Problem:

Multiple application teams charging to same project / charge code.

In the details tab, every distinct application is listed with their respective projects. However, in some cases, 2 apps employees may be charging time to the same proj id and or charge code.

When i do a sumif/vlookup, it sums the same values for each application that are working on the same proj id and charge code.

How do i get the correct sum for each?

In the Data tab, the application is not listed in the same row as the employee which could identify him/her to that app.However, i have a table that associates each employee to an app. An employee can be linked to 2 or 3 apps that they charge time to.

**DonkeyOte** · 10-09-2010, 03:38 AM

Not very clear I'm afraid - it would help I think if you outlined expected results based on the sample.

In your file some of the App values in Data Dump do not match those of Details sheet - D2/D12 having a space unlike the Details values.

It may be the case that you want:

Please Login or Register  to view this content.

but that's something of a guess and is based on assumptions that a) you're working with XL2007 (or above) and that b) the inconsistencies of App values is result of typo

If either a) or b) does not hold true (eg you need backwards compatibility or App values can be inconsistent) then you're looking at SUMPRODUCT*

* alternative would be to use a concatenation field... preferable if working on large data sets

**Charlie_Howell** · 10-09-2010, 05:10 PM

Try this and let me know if this is what yer lookin for. P.S. make sure that all of your data is entered the same, ie. (App1 - App 1) the spaces act as a character and the formula will not pick it up in your criteria.

**DonkeyOte** · 10-09-2010, 05:20 PM

@Charlie_Howell - it would seem that the attachment is just a repetition of the prior suggestion - or am I missing something ?

**rz6657** · 10-09-2010, 06:55 PM

This works... thanks to all that helped....

Sum where application employees diff but charge code same

LinkBack

Thread Tools

Rate This Thread

Display

Sum where application employees diff but charge code same

Re: Sum where application employees diff but charge code same

Re: Sum where application employees diff but charge code same

Re: Sum where application employees diff but charge code same

Re: Sum where application employees diff but charge code same

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions