index match sumif - adding mulitple cells with the same criteria

**Tresfjording** · 05-04-2019, 05:49 AM

Hi ...

Working on a spreadsheet here, trying to make a revolution within the world of soccer punters.

I try to sum up Man City's Full Time Home Goals in sheet "matches" and column D
In other words; I am trying to sum column D for every cell in column B containing "Man City"

The sum should be 56, but I get only 21.
What am I doing wrong?
Of course I use CTRL+SHIFT+ENTER.

My formula:

Formula:

Please Login or Register  to view this content.

thanx in advance
Tresfjording

**Tresfjording** · 05-04-2019, 05:56 AM

In fact I get wrong answers all over the place using this formula.

**Pepe Le Mokko** · 05-04-2019, 05:57 AM

Like this ? =SUMPRODUCT((B2:B361="Man City")*D2:D361)
( no CSE needed)

**Tresfjording** · 05-05-2019, 04:25 AM

That simple huh?!?

It WORKED !!!

Thanx, pepe

index match sumif - adding mulitple cells with the same criteria

LinkBack

Thread Tools

Rate This Thread

Display

index match sumif - adding mulitple cells with the same criteria

Re: index match sumif - adding mulitple cells with the same criteria

Re: index match sumif - adding mulitple cells with the same criteria

Re: index match sumif - adding mulitple cells with the same criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Index match formula with mulitple criteria ('if' result less than/greater than 0)???

Sumif Index match with multiple column same criteria

[SOLVED] index match and sumproduct or sumif on multiple criteria

[SOLVED] Index/Match with mulitple criteria referencing same table

[SOLVED] need help on Sumif with index and match multiple criteria

Mulitple Criteria Index,Match or Evaluate issue

Sumif Index match with multiple column headings same criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions