Say I have a 6 columns, the first five show the price of apples, oranges, bananas, pears & grapes, and the last a country (eg US, UK etc). Then lets say I have a 100 rows of those 6 pieces of data. I can easily total each column =sum(A1:A100), but how would i go about totalling only specific rows, eg the cost of bananas in each row marked UK?
you get better help on your question if you add a small excel file, without confidential information.
please also add the expected result manualy in the file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
=SUMIF, (or SUMIFS if there's multiple criteria) with the column containing UK in a part of the formula.
Pete
I agree with oeldere. A sample file is very helpful in getting solutions.
In the mean time. Try working with the SUMIFS function.
Hope this is helpful.
I think SUMIF is what I'm looking for, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks