Sumproduct based on employee number and column titles

**jantonio** · 01-21-2018, 02:23 PM

Hello,

I'm having a small issue with my sumproduct formula and would ask of your kind assistance.

Somehow is only giving me a total "0" value. I would like it to be a total based by employee number and column titles.

I have attached a sample file.

Thanks for pointing me in the right direction.

**reimar_rem** · 01-21-2018, 02:36 PM

Originally Posted by jantonio

Hello,

I'm having a small issue with my sumproduct formula and would ask of your kind assistance.

Somehow is only giving me a total "0" value. I would like it to be a total based by employee number and column titles.

I have attached a sample file.

Thanks for pointing me in the right direction.

Hi,

Try this:

Formula:

Please Login or Register  to view this content.

instead of (data)*(data)*(data)

**JohnTopley** · 01-21-2018, 02:57 PM

Try

in CB2

=SUMPRODUCT(($B$2:$B$100=$B2)*($K$1:$BP$1=CB1)*($K$2:$BP$100))

copy across

**jantonio** · 01-21-2018, 04:10 PM

Thank you so much! That did the trick.

Sumproduct based on employee number and column titles

LinkBack

Thread Tools

Rate This Thread

Display

Sumproduct based on employee number and column titles

Re: Sumproduct based on employee number and column titles

Re: Sumproduct based on employee number and column titles

Re: Sumproduct based on employee number and column titles

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Creating text string based on column titles and values below

Macro that will show the correct value based on employee number

Employee titles matching office types verification

[SOLVED] Search for employee ID, based on Employee Name

Pull row/column titles based on values inside an array

Changing the column titles to the spreadsheet titles when scrolling down

Return employee name when the employee's number is entered

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions