Need assistance on a IF then statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Alright, I am trying to create a formula that will do the following:

column C with and X and column I with EL, then your sum up column J
Here is the way I did it but it keeps coming back with a #value! error.

=IF(AND($C$7:$C$14,"x",$I$8:$I$14,"EL"),J8:J14)

any assistance would be appreciated. Basically I want to condition to exist
in order for column J to add it's totals. What am I doing wrong.

thanks

Tim Beltramo
 
Tim B said:
Alright, I am trying to create a formula that will do the following:

column C with and X and column I with EL, then your sum up column J
Here is the way I did it but it keeps coming back with a #value! error.

=IF(AND($C$7:$C$14,"x",$I$8:$I$14,"EL"),J8:J14)

any assistance would be appreciated. Basically I want to condition to exist
in order for column J to add it's totals. What am I doing wrong.

thanks

Tim Beltramo
Click to expand...
 
Back
Top