Using VBA with a SUMIF Function to populate a report worksheet

[noboffinme]

Hi,

I have an Excel report that contains a lot of Excel SUMIF Functions & as it has grown, it has become really slow to update.

I thought of using VBA to speed this process up & wondered if anyone had any report examples or a method to populate Cells using VBA with SUMIF.

Otherwise, does anyone have better option to populate Cells in a Worksheet using VBA that relies on more than one criteria?

Thanks in advance. : )

[NeedForExcel]

Can you attach a sample workbook?

[noboffinme]

Hi NeedForExcel,

I've mocked up an example worksheet where I'd like to populate the tables Cells 'B5' - 'K8' Based on the Headings in the table.

All help appreciated!

[NeedForExcel]

Don't understand your Excel..

What is the logic to populate the tables Cells 'B5 - K8'?

[Old4xford]

If you could modify your example to include what it is you're looking for (even if you have to manually type it in), and/or perhaps a desensitized snippet of your Sumif formula to give us something to start with?

[noboffinme]

Hi Again,

I've made a working example of how I would create a SUMIF table using the SUMIF Formula.

The cells shaded green are the ones I want to use VBA to populate instead of using a Formula.

Hope this helps.

[NeedForExcel]

I think for a problem like this, SUMIF (With Concatenated Values) or SUMIFS would be the best option.

[AB33]

Try the attached.

[NeedForExcel]

@AB33

Very nice coding..

[noboffinme]

Hi AB33,

Thank you very much, I've been coding for a while but some of your code is new to me.

Could I trouble you for some comments on your code so I can understand your logic?

Thanks again, this is exactly what I was after!!

[noboffinme]

Hi AB33,

I've got the idea now, this is very efficient, thank you.

[AB33]

I tried to send you a private message, but it is not working and have already reported it.