using sumifs in excel vba

[I burticus]

The code below works fin but I want to loop the sum to get a total so I have changed it to

Subtot = [=SUMIFS(Data!E2:E126,Data!C2:C126,wsv.Cells(1,I))]

if I hover over the panel it shows me the correct info but always return's a zero as the result.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please Login or Register  to view this content.

Confused, please repair my sanity.

[6StringJazzer]

The syntax looks OK to me so the problem could be that this is the wrong formula for your data, or the problem could be in the data itself. Could you attach your entire file?

To post a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots

[I burticus]

6StringJazzer

Appreciate the insight and have attached the entire file.

What I am trying to achieve is for the function to calculate the total value of a products accumulated risk phrases.

Although there are several sheets no data has been loaded yet except for some test data to the sheet 666-58 series and the actual data on the data sheet.

Again thanks for your help,

Regards,
I Burticus.

[romperstomper]

Use:

Please Login or Register  to view this content.

although you don't seem to be doing anything with the tot variable.

[I burticus]

Thank you romper stomper, much appreciated.

The tot variable is going to be added to Listbox1 to show the products in order of numerical rank and therefore highest potential risk

Thanks again,

regards,
I Burticus