 SOLVED

# SUM formula help needed with multiple criteria

I need to multiply the cost per piece & the number of pieces being ordered. I need the formula to continue down the entire column. The formula I'm using for an example is  =SUM(J111*H111)

I need that formula repeated in column H continuously with the correct corresponding cell numbers. It was working fine, although I don't recall how I did it. Now the cell numbers are mixed up.

I hope I explained myself correctly. Any help would be appreciated.

5 Replies

# Re: SUM formula help needed with multiple criteria

Hi Eileen,

You sum nothing, just multiply the price on number of pieces, thus formula like

`=J103*H103`

is enough

And your formula for 110 is wrong, it looks like

`=SUM(J110,H110)`

it shall be * instead of comma. Even better

`=J110*H110`

# Re: SUM formula help needed with multiple criteria

Thank you! I appreciate your help. It's much simpler than I thought. Now the most important question... Is there a way to have that formula repeat in column K continuously? Without having to type in the formula in each cell in the column?
Best Response confirmed by Eileen Skidgel (New Contributor)
Solution

# Re: SUM formula help needed with multiple criteria

Eileen,

- enter formula in the first cell of your range, let say =J1*H1 in cell K1;

- select your range in column K, let say cells from K1 to K200;

- press Ctrl+D

It's not necessary to empty your range before

# Re: SUM formula help needed with multiple criteria

Thank you very much! Going to try it now.

Have a wonderful day!

Thanks, you too