COUNTIFS/SUMIFS formula

[banneduser123]

Hi,
I'm trying to write the below formula.

Column E has the word "buy" or "sell" in it
Column F particular date in it
Column C has a dollar amount in it

I want to write a formula that will sum up the dollar amounts in column C of all the instances where it shows the word "sell" in column E, and the date in column F is 8-15 days from the last day of that month.

Is that clear?

Thanks in advance

 

[banneduser123]

Re: COUNTIFS/SUMIFS formula help

if it makes it easier, I can alter the above regarding the date portion.

can you help with this instead:

I want to write a formula that will sum up the dollar amounts in column C for all the instances where it shows the word "sell" in column E, and the date in column F is 8-15 days from the date in cell A2.

 

[banneduser123]

Re: COUNTIFS/SUMIFS formula help

well, this should help make it easier...changing the date issue again:

so this is finally what I'm looking for:

I want to write a formula that will sum up the dollar amounts in column C if it meets the following criteria:

- if it shows the word "sell" in column E
- if the number in column S is between 8-15

 

[banneduser123]

Re: COUNTIFS/SUMIFS formula help

nevermind, figured it out on my own...going to be using this:

=SUMIFS('filename'!$J:$J,'filename!$L:$L,"BUY",'filename'!$S:$S,">=0",'filename'!$S:$S,"<=1")

 

[banneduser123]

Re: COUNTIFS/SUMIFS formula help

how do I make this return an absolute number? trying to add =ABS in front of it, but it doesn't work...

=ABS(=SUMIFS('filename'!$J:$J,'filename!$L:$L,"BUY",'filename'!$S:$S,">=0",'filename'!$S:$S,"<=1")/1000)

 

[banneduser123]

Re: COUNTIFS/SUMIFS formula help

nevermind, figured that out too..had to get rid of the = in front of SUMIFS