Woring with multiple criteria to sum a value

[steve wills]

Hi All,

I have a spreadsheet and need to sum a value between 2 dates that also meet a third criteria.

I have a data sheet called data with column A (account numbers), column B (Dates) and column C values (number) .

I have another sheet with a cell that has a date (this is my start date) then another cell (this is my end date) and the third cell an account number.

I want to add the values in Data (Column C) that are between (start date) and (end date) which also meet a specific (account number)

Any help would be great.

 

[Jake Collins]

=sumifs(c:c,b:B,,">="&StartDate,b:B,,"<="&EndDate,a:a,AccNo)

 

[Mike H..]

Try this

=SUMIFS(Data!C1:C100,Data!A1:A100,C2,Data!B1:B100,">"& A2,Data!B1:B100,"<=" & B2)


Where

A2= Start date
B2= End date
C2= Ac Number