Insert Sumif formula but range may change

**batchy** · 03-06-2014, 02:22 PM

Hi,

I have created the attached workbook and a macro which i am to roll up performance.

The issue i have is each day the data input will increase so a standard

Please Login or Register  to view this content.

formula will not work.

If you look at "Daily (Data)" i would like a formula in there which does a sumif but excludes brand. As stated above the current source data runs from row 2:19 but this will change on a daily basis. Is there any code which i can use to auto select the 1st section for the sumif calculation?

Kind Regards

**JBeaucaire** · 03-07-2014, 12:36 AM

SUMIF allows the sum of one range using a filter on an adjacent range by some single criteria:

=SUMIF(A:A, "Cat", B:B)

If you need more than one criteria, switch to SUMIFS which allows as many filtering criteria as you wish:

=SUMIFS(B:B, A:A, "Cat", C:C, "Boston")

As long as there isn't junk in the same columns further down, there's no need to limit a SUMIF or SUMIFS to any specific set of rows, it is very robust if refer to columns as a whole.