# SUMIF condition

Options
✭✭
edited 12/09/19

Hi guys!

I have to calculate average in my sheet and I will use: SUMIF / COUNTIF

- COUNTIF formula is working.

- SUMIF formula is not working, i am getting #INVALID OPERATION

The SUMIF formula is (screenshot attached) =SUMIF([Assigned to in Region]8:[Assigned to in Region]136, "Sarah Mabiletsa", [Quote Prep Cycle time]8:[Quote Prep Cycle time]136)

The Assigned to is a contact list column

The Quote Prep is a text/number column (the numbers are coming from a formula)

Can someone help out?

Fede

Tags:

• ✭✭✭✭✭✭
Options

Hi Fede,

First thing I recommend you check is if the value coming from the formula is recognized as text or a number.

You might need to convert it to a number with the VALUE function.

What did you find?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
edited 05/17/19
Options

Hi Andree'!

Thanks for picking this up! unfortunately it is not working... please see the screenshots.

Cheers,

Federico

• ✭✭✭✭✭✭
Options

Remove the VALUE function from your SUMIF formula but leave it on the RFQ Sent - RFQ Received formula.

• ✭✭
Options

Thank you Paul - it worked out.

The SUMIF / COUNTIFS worked in another sheet, with references to the original one, no need to use VALUE.

Cheers,

Federico

• ✭✭✭✭✭✭
Options

Happy to help!

Let me know if I can help with anything else!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!