Help with formula

[Dick]

Can someone please help. I have several ifs statements that I need in
a formula. Sheet2 has a column with square feet. Column (D) that
totals all sq ft, with total results in Sheet2 (K4). On Sheet1 (H4)
I'd like for the results to be: If Sheet2 (K4) <= 25 then Sum Sheet1
(C:C)*1, If Sheet2 (K4) >25<75 then Sum Sheet1 (C:C)*2. If Sheet2 (K4)
=75<100 then Sum Sheet1 (C:C)*3 and so on... For every 25 I would like
for it to Sum then multiply. Thanks in Advance!!!

 

[joeu2004]

Sheet2 has a column with square feet. Column (D) that
totals all sq ft, with total results in Sheet2 (K4). On
Sheet1 (H4) I'd like for the results to be:
If Sheet2 (K4) <= 25 then Sum Sheet1 (C:C)*1,
If Sheet2 (K4) >25<75 then Sum Sheet1 (C:C)*2. [....]
For every 25 I would like for it to Sum then multiply.

=SUM(C1:C1000)*ROUNDUP(Sheet2!K4/25,0)

 

[joeu2004]

If Sheet2 (K4) <= 25 then Sum Sheet1 (C:C)*1,
If Sheet2 (K4) >25<75 then Sum Sheet1 (C:C)*2. [....]
For every 25 I would like for it to Sum then multiply.

=SUM(C1:C1000)*ROUNDUP(Sheet2!K4/25,0)

But note: I paid attention to your English description ("for every
25"), not your examples (">25<75" and "=75<100"). The two do not
agree.

If you do not mean "every 25", please provide more examples --
multiply by 4, 5 and 6.

And be v-e-r-y careful with your boundaries. "<=25", ">25<75" and
"=75<100" seem inconsistent. The latter two also are not valid
expressions of ranges. Use the for "x<=25", "25<x<75" and "75<=x<100"
to be precise.

 

[GS]

joeu2004 explained :

If Sheet2 (K4) <= 25 then Sum Sheet1 (C:C)*1,
If Sheet2 (K4) >25<75 then Sum Sheet1 (C:C)*2. [....]
For every 25 I would like for it to Sum then multiply.

=SUM(C1:C1000)*ROUNDUP(Sheet2!K4/25,0)

But note: I paid attention to your English description ("for every
25"), not your examples (">25<75" and "=75<100"). The two do not
agree.

If you do not mean "every 25", please provide more examples --
multiply by 4, 5 and 6.

And be v-e-r-y careful with your boundaries. "<=25", ">25<75" and
"=75<100" seem inconsistent. The latter two also are not valid
expressions of ranges. Use the for "x<=25", "25<x<75" and "75<=x<100"
to be precise.

My understanding of the OP's request is that he wants the formula to
work for each increment of 25. I believe you got it right!

I was working on a reply when your post appeared so I didn't bother
posting since we were on the same track. (Only difference to mine is I
used absolute refs: 'Sheet2!$K$4')