Calculate cells if other cell contains a value - Need help with the logic.

[audioboxer]

I am trying to calculate a series of cells but only if adjacent cells contain data. I can't think of the right formula for this. If someone could lead me in the right direction I should be able to do the rest I just can't think of the right one.

Here is the example. Cells A1, C1, E1, and G1 contain Sales dollars where B1, D1, F1, H1 contain the Budget. In I1 I have the running total for sales. In J1 I want to sum each of the budget dollars but only if there is a value in the sales dollars cell next to it.

To sum it up I think this is what I am looking for: SUM B1(if A1 > 0), D1(if C1 > 0), F1(if E1 > 0), H1(if G1 > 0)

I hope this makes sense.

thanks in advance.

[Pepe Le Mokko]

Please post a sample sheet - Thx

[Ferloft]

=SUM(IF($A1<>"",$B1,0),if($C1<>"",$D1,0),if($E1<>"",$F1,0),if($G1<>"",$H1,0))

[Jonmo1]

Is that a REAL example of what you want, or a simplified version of something more complicated?

It's usually best to post a real world example of what you want, using the actual cell references and values.
Because the solution to the simplified version is often very difficult to adapt to the real version of the issue.

[Ace_XL]

Try

=SUMPRODUCT(B1:H1,--(A1:G1<>""),--(MOD(COLUMN(B1:H1),2)=MOD(COLUMN(B1),2)))

[audioboxer]

=SUM(IF($A1<>"",$B1,0),if($C1<>"",$D1,0),if($E1<>"",$F1,0),if($G1<>"",$H1,0))

Perfect, thank you. I was close, I appreciate the help.

[audioboxer]

Now I implemented this into the project and realized it won't work because where there are blanks there are actually #N/A values because I have it pulling data with VLOOKUP. Normally I would use the aggregate function to calculate in a case like this but I couldn't get the aggregate function to work with the IF function. I would appreciate any help with this.

[audioboxer]

Here is a quick example sheet if this helps.. Thank you. Formula.xlsx

[Jonmo1]

Probably best off to adjust your vlookups so they don't return #N/A errors

=IFERROR(VLOOKUP(...),0)