small change

=IF(AND(B41=0,J33=0),"",IF(AND(J330,B410),SUMPRO DUCT(J33:J37,I41:I45)*12,*
SUMPRODUCT(B41:B45,C41:C45)*12))


SUMPRODUCT(J33:J37,I41:J45) change to SUMPRODUCT(J33:J37,I41:I45)



On Sep 25, 3:01*pm, lsgKelly
wrote:
Here's what I have, but it's returning a #Value error. *It might help you
understand what I'm trying to do.

=IF(AND(B41=0,J33=0),"",IF(AND(J330,B410),SUMPRO DUCT(J33:J37,I41:J45)*12,*SUMPRODUCT(B41:B45,C41:F 45)*12))

I have two cells, B41 and J33. *If B41=0, then I want it to return a blank
cell. *If J33 is greater than 0, then I want it to do this part of the
function: SUMPRODUCT(J33:J37,I41:J45)*12

If J33=0 but B410, then I want it to return this part of the function:
SUMPRODUCT(B41:B45,C41:F45)*12

Hope that helps. *:)



"Mike H" wrote:
Kelly,

I might be being a bit slow but I don't understand the question. Can we see
a couple of sample lines of data and the answer(s) you expect to get from
that data?

Mike

"lsgKelly" wrote:

I have to write a formula that accomplishes the following task:

I have a spreadsheet that has three columns. *The columns are "Subs1"
"Subs2" and "RATE1". Here's what I want it to do:

If Subs1 = 0 and Subs2 = 0, ""
If Subs2 0, sumproduct (subs2,rates1)
If Subs1 0 and Subs2 = 0, sumproduct(subs1,rates1)

I know this isn't all that difficult, but for some reason, it is not working
for me.

Thanks in advance!

Kelly- Hide quoted text -

- Show quoted text -