Sumif between visible cells only

[sdoppke]

Hi I am struggling to find examples on how to sumif between visible cells.

Here is the formula I am trying to adapt to visible cells only: If it matters Q4 and R4 are cells with TIME values.

=SUMIFS(C:C,G:G,">="&Q4,G:G,"<"&R4)


Thanks for any help or direction!
SD

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html

 

[sdoppke]

Have a look here https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html

Thank you, I did see that. Where I struggle is how to adapt that to allow for "between" part (>= x, < y).

SD

 

[Fluff]

Ok, how about https://www.mrexcel.com/forum/excel...ing-multiple-criteria-sum-changes-filter.html

 

[sdoppke]

Ok, how about https://www.mrexcel.com/forum/excel...ing-multiple-criteria-sum-changes-filter.html

Thanks again: based on that thread. I came up with:
=SUMPRODUCT(SUBTOTAL(9,OFFSET(C6,ROW(C6:C18431)-ROW(C6),0)),--(G6:G18431=Q4),--(G6:G18431=R4))

But I am returning 0 rather than the correct number.

Any ideas where I might be going wrong?

SD

 

[Fluff]

Should it be
=SUMPRODUCT(SUBTOTAL(9,OFFSET(C6,ROW(C6:C18431)-ROW(C6),0)),--(G6:G18431>=Q4),--(G6:G18431<=R4))

 

[sdoppke]

Should it be
=SUMPRODUCT(SUBTOTAL(9,OFFSET(C6,ROW(C6:C18431)-ROW(C6),0)),--(G6:G18431>=Q4),--(G6:G18431<=R4))

Bam! that was it! thank you very much!

 

[Fluff]

Glad to help & thanks for the feedback