Looking for formula that involves 2 columns

**gerryger** · 09-03-2009, 12:35 AM

I attached the sheet which explains what I am attempting to do

**navwelch** · 09-03-2009, 01:00 AM

=sumif(f2:j13,f2,j2:j13)

**romperstomper** · 09-03-2009, 04:02 AM

You should only refer to one column in the criteria range:
=SUMIF(F2:F13,F2,J2:J13)
or if you specifically want Pat:
=SUMIF(F2:F13,"Pat",J2:J13)
for example.

**gerryger** · 09-03-2009, 06:31 AM

Originally Posted by romperstomper

You should only refer to one column in the criteria range:
=SUMIF(F2:F13,F2,J2:J13)
or if you specifically want Pat:
=SUMIF(F2:F13,"Pat",J2:J13)
for example.

I did forget to mention that the result in the above formula (which works) eventually gets divided by another cell Ex:=SUMIF(F2:F13,"Pat",J2:J13)/N6
If the value in N6 is 0 I get the /DIV0! error

What I can I add to the above formula to hide the error

Thanks

**romperstomper** · 09-03-2009, 06:38 AM

Depends what you want returned:
=IF(N6=0,"",SUMIF(F2:F13,"Pat",J2:J13)/N6)
for example.

**navwelch** · 09-03-2009, 06:44 AM

=IFERROR(SUMIF(F2:J13,F2,J2:J13)/N6,"nil")

you may substitute any text or number for the word "nil" like 0, or even empty space for which you have to give "".

**romperstomper** · 09-03-2009, 06:48 AM

Note that IFERROR does not exist in versions prior to 2007. You would need to use:
=IF(ISERROR(formula),"error value",formula)

Looking for formula that involves 2 columns

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Re: Looking for formula that involves 2 columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions