DebbieoCopper ContributorApr 30, 2019Excel query Hi, I am trying to sum column G2:G50 but only if the amount in column E2:E50 is larger and equal to 0.01 and less and equal to 10,000 what formula's can I use? Hope this is clear. Any help will be ...Show More
TwifooSilver ContributorApr 30, 2019Use SUMIFS like this:=SUMIFS(G2:G50,E2:E50,”>=“&0.01,E2:E50,”<=“&10000)
DebbieoCopper Contributor to TwifooApr 30, 2019Twifoo thank you, this helped, I had something similar but didn't pay attention that I had mixed up the columns.
