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...
HansVogelaar This is very basic idea. As you notice in tab "Costs" its saying 0, but there is data in the data tab.
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