How do perform the Sum

[daffyyd]

Hi All,

Am working on a large data that is repeatative and I would like to have function to assist. Am new to VBA

I have a sheet (Called it Sheet 1) that has got 18 columns and Hudreds of rows. The number of rows depends on the query from another source.I have created 2 parameters in Sheet 2 and Command Button. Parameter 1 is data that is in Sheet 1column C and Parameter 2 is data in Sheet1 column E.

My aim is to Sum column R if Paratemer 1 and 2 are met and have the sum value in Sheet 2 Row 10 column 2.

How do I achieve this.

Please assist

Regards
David

 

[Weaver]

Welcome to the board!

Might I ask first what version of Excel you're using, as this could have a bearing on any approach to this.

 

[daffyyd]

Thanks so much for the links. I will definately go through them.

Am using Excel 2007.

Below is the link to sample Data

http://www.mediafire.com/?b8e38x0l14n8knd

Regards

 

[jasonb75]

Try

=SUMIFS(Sheet1!R:R,Sheet1!C:C,parameter1,Sheet1!E:E,parameter2)

Change the sheet names and parameters to match the correct ranges in your sheet.

 

[daffyyd]

Thanks,

It worked ok

Regards
David