SumIfs Formula

[MohanadElnashar]

=SUMIFS($D:$D,$C:$C,H9638,$E:$E,"="&L9638)

I used this formula for a spreadsheet that contains stock names, the total stocks owned (either sold or bought), and the value>


at the top of the table the date is written
i want to sum for a certain stock on a certain date the amount bought rather than going through them one by one as there is more than year worth of data on stocks bough and sold with theri value
so the i tried the sumifs formula above but it does not work

the D:D is the amount of stock owned, the C:C IS THE name of the stocks, the E:E is where the dates above each table is written, the L9638 is the date i'm searching for, and the H9638 is the stock name

if i change the equal sign to more than sign it works but with the equal sign it gives not data back

 

[etaf]

why not just use the cell ???

=SUMIFS($D:$D,$C:$C,H9638,$E:$E,L9638)

if you want a range of dates , then have the lower and higher dates in 2 cells
=SUMIFS($D:$D,$C:$C,H9638,$E:$E,">="&L9638, $E:$E,"<="&other cell )

 

[FormR]

if i change the equal sign to more than sign it works but with the equal sign it gives not data back

Hi, do your dates in column E also have a time element?

If so, you could try like this:

=SUMIFS($D:$D,$C:$C,H9638,$E:$E,">="&L9638,$E:$E,"<"&L9638+1)