# Get instant live expert help on sumif and sumifs

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

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