SUM values with criteria

**danxavy** · 01-05-2021, 09:46 AM

Hi
New to this forum so if I don't explain myself clearly please let me know. I think I have attached the file but not sure if I have done it correctly.

I am now pulling my hair out as I just can't seem to get the formulas to work in this case.
The attached file is an extract from a bigger Excel. What I am trying to achieve is to count the PC Models under each country (there are more) by recognising the model name and then adding the numbers that correspond to the model to the monthly Count grid
I know I could just use =SUM but the attachment is not the whole story just a part of the Excel file so I need to use the countif or sumif or a combination or perhaps something else I don't know about. I will be adding more models and months in the future.
=COUNTIF(A:A, "ThinkPad T14") -- this is formula that recognises the ThinkPads T14 entries in column A.
Now I need the formula to add the total monthly numbers from column B that correspond to the ThinkPad T14's into the Count grid cell H3, which would be the sum of B5,B12,B19 and B26 (6)
I then need to do this for the other models which would just be a matter of changing the model name in the formula.

Is that clear as mud or do you get me? I am sure there is a really easy solution but now my mind is all over the place!

Thanks in advance for you help.
Br
DanComputerCount.xlsx

**Glenn Kennedy** · 01-05-2021, 09:52 AM

In H3, copied across and down:

=SUMIF($A:$A,$G3,$B:$B)

**Glenn Kennedy** · 01-05-2021, 09:53 AM

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

**danxavy** · 01-05-2021, 10:19 AM

Thank you Glenn and understood about the title.

This was a case of: "Sometimes things are most likely so easy that it's too difficult"

Thanks again and Happy New Year to you!
Br
Dan

**Glenn Kennedy** · 01-05-2021, 10:27 AM

Exactly... Sometimes you're just too busy going in circles. It happens all the time... to all of us.

You're welcome.

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

SUM values with criteria

LinkBack

Thread Tools

Rate This Thread

Display

SUM values with criteria

re: SUM values with criteria

Re: SUM values with criteria

Re: SUM values with criteria

Re: SUM values with criteria

Thread Information

Users Browsing this Thread

Similar Threads

Index match with multiple criteria when one criteria requires to exclude values from searc

Grouping by one criteria and then bild values per group based on each different criteria

Create a unique list of values that match a criteria, sorted in order of another criteria

[SOLVED] Count number of rows that match criteria and apply values relative to another criteria

VBA Macro Dividing Values Based upon Matching Criteria and Description Criteria

[SOLVED] How to sum values based on multiple criteria with multple possibilities for each criteria?

Excel 2007 : Adding Values In Columns with Multiple Criteria Where Column Head is One Of Criteria

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions