Forum Discussion
Formula for adding certain cells
Hey Folks Not sure if this is possible. I need a formula that will add cells together depending on what is put in another cell. So if in A it says 1 - I need to add up all the amounts in C tha...
The numbers you want to sum are in column D, so the first argument (the sum_range) should be Data!D:D.
The codes are in column A, so the first criteria range should be Data!A:A.
=SUMIFS(Data!D:D,Data!A:A,"A-QW",Data!B:B,">="&$S$1,Data!B:B,"<="&$T$1)
sum_rng, crit_rng1, criteria_1, crit_rng2, criteria2, crit_rng3, criteria3
D'oh! so simple. Thank you so so much