Still Sumif Question

Just a quick look in your formula resulted little change in range reference

=sumif(o12:o18,$q44,r12:r18) Or =sumif(o12:o32,$q44,r12:r32)

To better describe about your problem just attach a sample workbook with expected output for getting exact and faster solution.

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.

Why not...

R44 =SUMIFS($R$12:$R$32,$O$12:$O$32,$Q44,$S$12:$S$32,"C")
T44 =SUMIFS($R$12:$R$32,$O$12:$O$32,$Q44,$S$12:$S$32,"CK")

My suggestion would be to add the SUMIFS together, but maybe there is a better way...

In R44 copied down

Please Login or Register  to view this content.

Believe it or not, this will work for the totals:

R44: =SUMIF($S$12:$Y$32, "C", $R$12:$X$32)
T44: =SUMIF($S$12:$Y$32, "CK", $R$12:$X$32)

Hi Jerry,

Thanks for the help...

I knew about the overlapping ranges, but since the date in Column O has to match the value in Q44 the overlapping technique does not seem to do the trick.

For Cash only row by row by date, this seems to work:

R44: =SUMPRODUCT(($O$12:$O$32=$Q44)*($S$12:$Y$32="C"), $R$12:$X$32)
T44: =SUMPRODUCT(($O$12:$O$32=$Q44)*($S$12:$Y$32="CK"), $R$12:$X$32)

...copied down.

Thanks Jerry, this works great...

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.