Match group number to points

**chuam** · 04-18-2019, 08:56 AM

Hi,

I need to use a formula that can calculate the number of points a group is given, as attached in this photo. How do I do so, assuming i insert the formulas within E2:E9?

excel help.jpeg

Thanks in advance!

**Melvosh** · 04-18-2019, 08:57 AM

Try this in E2 and drag down:

Please Login or Register  to view this content.

Did that give you what you're looking for?

**Sam Capricci** · 04-18-2019, 08:59 AM

Melovsh, i think you want =SUMIF($A$2:$A$13,$D2,$B$2:$B$13) instead.

**Melvosh** · 04-18-2019, 09:02 AM

Hah, you're totally right. People at work keep distracting me with work!

**Sam Capricci** · 04-18-2019, 09:06 AM

Hah, you're totally right. People at work keep distracting me with work!

yeah, I know what you mean, I hate when that happens.

**chuam** · 04-18-2019, 09:24 AM

Yes, that worked for me! thank you!

Match group number to points

LinkBack

Thread Tools

Rate This Thread

Display

Match group number to points

Re: Match group number to points

Re: Match group number to points

Re: Match group number to points

Re: Match group number to points

Re: Match group number to points

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help with assigning a sequential number for sub group of a group?

"Flagging" a number in one group when it matches a number in another group

Calculate rotation/translation matrix to match measurement points to nominal points

Have a group of field change to highligheds if it contain a number from another group

How to add the number to the data points if it has more than 1 million points

Daily Average of 50,000 data points, different number of data points each day

[SOLVED] Establish ranks by group and points with a twist?

Bookmarks

Bookmarks

Posting Permissions