“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Can SUMIF and SUMIFS calculate on only what is visible? The same way Subtotal(9,...... works? In the example, if I filter on a country I want the SUMIF(S) to calculate only on the filtered data,

Solved by V. F. in 16 mins

I am trying to utilize a complicated sumif or sumifs formula that can pull a total amount from a date and a drop down box from another tab.

Solved by E. B. in 25 mins

Hello Experts, I would request you to get me some complex examples for the functions of SUMIF,SUMIFS,COUNT,COUNTIFS,AVGIF,AVGIFS... Thank you...

Solved by X. B. in 16 mins

I am trying to sum column D based on non-blank containing dates in column C. I cant get it to work. I have tried: =sumifs(c3:c100, d3:d100, NOT(ISBLANK)) =sumifs(c3:c100, d3:d100, ISDATE) =sumif(d3:d100, c3:c100, NOT(ISBLANK)) None of these work. Help!

Solved by X. Q. in 25 mins

Hello I am looking for a SUMIFS formula where when I move the formula over to the next cell the SUMIFS sum column will move three columns over. The sumif formula in Cell C19 is =SUMIFS(TY!E:E,TY!$B:$B,TOTAL!$A$8,TY!$A:$A,TOTAL!$A$18) when I paste the formula over to cell D19 I need the formula to change from E:E to H:H

Solved by Z. B. in 13 mins