IF inside a SUMIF or vise versa, neither is working for me

[jls7d8]

So I have dollar amounts in column C and a corresponding date paid in column G


At the bottom of the sheet I have a cells where I enter in a specific date. IE I will enter in cell A50 date A and in cell A51 I will enter in date B.

I have the IF statement that works for a single cell IF(G42>E62,IF(G42<=E65,C42,0),0) but I want to apply that IF statement to a range of cells that will sum up the totals.

Can this be done all in a single cell with a single formula

IF((G14:G53)>E62,IF((G14:G53)<=E65,C42,0),0) was as far as I got and it doesn't work.

[jeffreybrown]

I'm a little lost by your cell references, but it's possible what you need is =SUMIFS(sum_range,criteria_range,criteria,...)

Mind posting a sample workbook with what you expect?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[Moo the Dog]

Assuming the totals you want to SUM are in the range of C14:C53

Try this:

=SUMIFS(C14:C53,G14:G53,">"&E62,G14:G53,"<="E65)

- Moo

[jls7d8]

Here is my example file

[jls7d8]

this one did not work...

[jeffreybrown]

Does this work better for you?

=SUMIFS(C14:C53,G14:G53,">"&E62,G14:G53,"<="&E65)

[Moo the Dog]

Does this work better for you?

=SUMIFS(C14:C53,G14:G53,">"&E62,G14:G53,"<="&E65)

Gah! I forgot to have the quotes around just the > and <=.

Thanks, Jeffrey

- Moo

[jls7d8]

How would I modify for the first date entry since there won't be a date before it?

[jls7d8]

Actually I got that, Thanks for all your help, it works great!

[jeffreybrown]

Glad you got it working. Thanks for the feedback and we are glad to have helped

-------------------------------------------------------------------------------------------------

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save