countif and vlookup

[vavs]

I am trying to sum a column from multiple worksheets based on three criteria from another worksheet. I have a worksheet for each month over the past year. In that worksheet I have a column called "useage". This value should be sum totaled if and only if the column "Accountnumber" is in a sheet called W1DISC and the 8th column = "1". To complicate matters, the accountnumber column is derived by a VLOOKUP of yet another worksheet. The VLOOKUP of the accountnumber is working famously.

Here is what I would like to do,

If accountnumber in sheet a is (in sheet b and column 8 = 1), then add the useage value to the total number of gallons. I would like to know the total number of accepted values so I can average them.

I think I am close, but I cannot seem to get to the end of this problem.

 

[Ron Morris]

Hi,

Don't know what the rest of your formula looks like but you can use an If fomula ahead of your sum formula.

=IF(W1DISC!B8=1,add your other formula here,"")

Hope this helps

Ron

 

[Todd Bardoni]

Your formula should be along the lines of:-

if(isna(vlookup)),"not_found",if(vlookup)=1,do_something)