Help writing formula

[gperez1127]

I need this formula =IF(SUM(AP18,BS18,CU18,DW18)>0,SUM(AP18,BS18,CU18,DW18)," ")
to be written like the one below, but using the same line and column references as above.
=IF(AND(ISNUMBER(N18*L18),MEDIAN(N18,L18,0)>0),N18+L18,"")
Help please

 

[RobertSF]

Well, this is both very simple and virtually impossible!

On the simple side, you'd think it's just a matter of substituting, but on the impossible side, the problem is that you have four columns in the first formula (AP, BS, CU, and DW), but only two in the second (L and N). What goes where?

Now, a third possibility is that they replace as a group. In that case, maybe this is what you want.

=IF(AND(ISNUMBER(AP18*BS18*CU18*DW18),MEDIAN(AP18,BS18,CU18,DW18,0)>0),SUM(AP18,BS18,CU18,DW18),"")

 

[Eric W]

Here's another possibility if they replace as a group:

=IFERROR(IF(MIN(AP18, BS18, CU18, DW18)>0,AP18+BS18+CU18+DW18,""),"")

In fact, if you're just using the MEDIAN to make sure that the values are numeric, just

=IFERROR(AP18+BS18+CU18+DW18,"")

using the + sign instead of SUM will cause an error if there's non-numeric data.