Help Calculating a sum with 2 conditions(!)

Hi tbailey and welcome to the forum

next time, please upload a sample workbook, not a picture. Pictures are nice and pretty, but impossible to edit.

based on the file name in your picture, it seems that you have 2007 or later, despite your profile saying 2003?

I would suggest you try using the sumifS() function, instead of just sumif()

If yoy still have a problem, perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).



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.

Could you upload a sample workbook, with some examples of what the data should be, and where it is not ?

Add a File - click advanced (next to quick post), scroll down until you see "manage attachments", click that and select "add files" (top right corner). click "select files", find your file, select file, click "upload", when the file shows up at the bottom left click 'done"(bottom right). click "submit reply"(remember the 1 MB limit, you may have to crop your file down to get it to a size that can be uploaded...)

Well it seems I have uploaded the workbook, if I am not mistaken.


Tab 3 is where I am referring everything to.


And I am using Excel 2010

Im not sure exactly what you want, but I think is the following formula doesnt give you what you need, it will at least show you a tool that you can modify to suite your needs...

=SUMIFS($K$2:$K$18,$L$2:$L$18,Q7,$M$2:$M$18,"NO")

Try this in P7:

Formula:

Please Login or Register  to view this content.

Drag down

in R7:

Formula:

Please Login or Register  to view this content.

drag down

I believe this gives the right results, but please double check

Hope this helps