Type Mismatch on SumIfs

[alteredbeast]

Hi,

I am trying to loop through a range to fill in a table of data using the sumifs function but I keep getting a type mismatch error.

I have attached the workbook. on the NB overview tab I am using the commission button to call the sub.

The figures in column A to E are the identifies for the month and year. the Raw data is all on the trans data tab

so far I have :

Please Login or Register  to view this content.

Its probably something really simple that I'm missing but I haven't had much practice in calling worksheet functions

Thanks

[xlnitwit]

Hi

The syntax for SumIfs requires pairs of ranges and criteria, not arrays of True/False, so you need this

Please Login or Register  to view this content.

[alteredbeast]

That's great. Thought it might be something simple and I should have known from using the function in excel.

Thanks for your help and sorry for being a dumb ***.

[xlnitwit]

You're welcome and thanks for the rep.

Also, believe me that is not a dumb question.