Do a Sumif. Use that value if it's less than another cell, otherwise insert another value

[Barking_Mad]

Hi,

I have the following but it doesn't work.

=IF(SUMIF(Q3:Q200, B25,R3:R200) < E25, SUMIF(Q3:Q200, B25,R3:R200), K11)

Im sure this is obvious, but I can't work it out despite trying for an hour!

*sigh*

[JohnTopley]

but it doesn't work.

meaning ????


Attach a sample workbook (not image).so that we do not have to manually key in your data to do a testing.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Barking_Mad]

Apologies, see original post.

Thanks

[Barking_Mad]

meaning ????


Attach a sample workbook (not image).so that we do not have to manually key in your data to do a testing.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Editing Q13 makes no difference to the output. I suspect Im using SUMIFS wrong, but I couldnt find a phrasing and answer to the way I wanted to do it.

Thanks

[davsth]

Your example doesn't correspond to the text in your post and you have not said what the result should be. It might be

=IF(SUMIF(M11:M14,I11,N11:N14)<K11,SUMIF(M11:M14,I11,N11:N14),K11)

but you have provided scant information

[FDibbins]

Based on the formula in yor file...
=IF(SUMIF(N11:N14,M11:M14,I11)<K11,SUMIF(N11:N14,M11:M14),Q13)

The syntax for both your SUMIF's are incorrect
Syntax is...
=SUMIF(Criteria-range, CRITERIA, sum-range)
The 1st sumif, you have the criteria and sum range swapped around, 2nd sumif, you have no criteria