# How to sumif criteria are in 3 columns (ie not the usual 1)?

1. ## How to sumif criteria are in 3 columns (ie not the usual 1)?

Hi there,

First of all my apologies if I don't respect the etiquette of this forum: I am very new and went straight for my question!

Not too sure how best to explain what I am trying to achieve but here it goes... .

In the column L "SUM 1+2+3", I would like to sum columns C, F and I IF and only IF the dates in columns B, E, H match the one in column K....
In L4 for example, the sum should be 40,000 + 40,000

Hope it makes sense? What is the right formula? If is something like sumifs or vlookup...?

Screen Shot 2015-07-13 at 10.21.46.png

2. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

Hi, welcome to the forum

1st, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

3. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

Thanks for the typs FDibbins.. How do I upload a sample of my workbook? I see an "insert image" button but no "insert file"?

4. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

A proper SUMIF formula:
Formula:
Please Login or Register  to view this content.

or a short array formula, has to be entered with Ctrl + Shift + Enter:
Formula:
Please Login or Register  to view this content.

(Does this look familiar, FDibbins?

5. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

6. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

Merci Jacc!! Vive google, vive internet et vive ce forum!!!!!
You made my day!!!

7. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, 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.

8. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

thanks, much appreciated!

9. ## Re: How to sumif criteria are in 3 columns (ie not the usual 1)?

''''''''''''

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1