asked on

Excel Fomula Count Question

Hello,

I have a report I need to add something to. I have an employee sheet that is already showing the dollars grossed each month for each individual, but I want to get a little more in depth. I want to make it so a certain part of an invoice (specifically the first word only) is what I am looking for in order to logic off of. Here is an example, Sheet 1 is where the employees are and Sheet 2 is my data. For Person 1 I want the dollar amount added up for anything with the first word being WG. The data I want to pull is the dollar amount added up (the sum of all WG's for this individual) which is next to the WG in its own column.

Sheet 1, a cell for the formula next to collector
Sheet 2 (columns), Employee ID, Amount, Payment Type.

Thank you.

SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

WO2015

ASKER

Hello,

Thank you. I edited the formula you had to match my columns but when I put the formula in and press enter its asking for me to pick a document and doesn't do anything.

=SUMPRODUCT((Sheet2!M2:M500=Sheet1!A3)*(Sheet2!E2:E500)*(LEFT(Sheet2!I2:I500,2)="WG"))

I have attached a test file that is generally similar (the columns are the same) with all of the content missing except for what we are working with.
TEST_110315.xlsx

ASKER CERTIFIED SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

WO2015

ASKER

Perfect, thank you! Sorry, I am so used to using Sheet1 and Sheet2.

Saurabh Singh Teotia

You are welcome...It's okay..Always Happy to Help.. :-)

Saurabh...