LinkBack URL
About LinkBacks
I attached the sheet which explains what I am attempting to do
I attached the sheet which explains what I am attempting to do
Please Login or Register to view this content.
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.
Everyone who confuses correlation and causation ends up dead.
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)/N6Originally Posted by romperstomper
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
Depends what you want returned:
=IF(N6=0,"",SUMIF(F2:F13,"Pat",J2:J13)/N6)
for example.
you may substitute any text or number for the word "nil" like 0, or even empty space for which you have to give "".Please Login or Register to view this content.
Note that IFERROR does not exist in versions prior to 2007. You would need to use:
=IF(ISERROR(formula),"error value",formula)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks