SUM with Criteria in Multiple Columns

[Marie007]

Hi all,

I'm trying to get the following to work in Excel:

If Column A has 'specific text' and Column B has 'specific text' it sums what is in Column C. Answer to be presented in Cell D

Therefore:

If Column A has "Apple" and Column B has "Free" it sums what is in Column C. Answer to be presented in Cell D = 4

Column A Column B Column C Cell D should say 4
Apple Free 4
Apple Cost 2
Orange Free 0


Hope this makes sense?

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new, I have done it for you this time.)

Are you in the UK? That's what's important in the location field of your profile.

[AliGW]

Sounds like you need a basic SUMIFS: https://support.microsoft.com/en-us/...6-611cebce642b

Shout if you are not able to apply the instructions given in the link.

[AliGW]

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

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[Marie007]

Hi,

That's spot on, thanks for your help :D