sum values if date matches a condition

[robertorosi]

Hallo; I am using excel 2010
in a sheet, in column A I have dates, in column B description, in column C amounts (i.e. A1 nov 13th 2012; B1 alan; C1 100; A2 sept 12th 2013; B2 philip;C2 300; and so on)
I want to sum amounts of column C IF B satisfies a condition (e.g. =alan) and date satisfies another condition (e.g. after jan 1st 2013, or after today)
I tried some functions, but it does not work
any suggestion?
thank You all

Roberto

[alansidman]

Look at using the =SumIfs function. Look at this link for the syntax.

http://www.techonthenet.com/excel/formulas/sumifs.php

[Debraj Roy]

Welcome to the forum..

I doubt.. "Nov 13th 2012" is a Date..

try again yourself.. by converting them to actual date.. or
upload a sample for us..

To upload.. "go Advance" and click the Clip Icon to upload a file..

[robertorosi]

probl excel.jpg
here is the example...

thanks

[L-Drr]

Something like this:

=SUMIFS(C1:C5;A1:A5;TODAY();B1:B5;"alan")

maybe my semicolon should be a comma for you

[robertorosi]

Something like this:

=SUMIFS(C1:C5;A1:A5;TODAY();B1:B5;"alan")

maybe my semicolon should be a comma for you

thank, but it works only if date matches TODAY, not before or after today, that is what I need
if I write
SUMIFS(C1:C5;A1:A5;>TODAY();B1:B5;"alan") I get a message of mistake

thanks all

[robertorosi]

thank, but it work only if date matches today, not before or after today
probl excel.jpg
here You can see the formula and the mistake....
thanks

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[alansidman]

The problem with pictures is that they don't show formatting. They don't allow those wishing to respond to see what the characteristics of your spreadsheet and lastly it takes time to re-create your spreadsheet. We are all volunteers here with limited amount of time to help as we all have full time employment (well most do). Please attach a spreadsheet that can be worked on directly.

[robertorosi]

sorry for that; I thought the screenshot was OK.....
here is the sheet; and thanks again
prova.xlsx

Roberto

[L-Drr]

Unfortunately I don't know how to implement checking for such criteria in a SUMIFS.
I do know you should remove the second = from your formula. That's one factor causing the error, I think.

[Olly]

Make the criteria ">"&today().

For example: =SUMIFS(C2:C7,A2:A7,">"&TODAY(),D2:D7,"A")

[robertorosi]

It works
Thanks a lot

Roberto

[L-Drr]

Make the criteria ">"&today().

Awesome, I'll remember that one. Don't know how many times I have used workaround-formulas for this

[alansidman]

Roberto,

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