COUNTIFS/SUMIFS formula

banneduser123

Banned - Rules violations
Joined
Mar 29, 2006
Messages
181
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
 
Last edited:

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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.
 
Upvote 0
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
 
Upvote 0
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")
 
Upvote 0
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)
 
Upvote 0
Re: COUNTIFS/SUMIFS formula help

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

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top