SUMIF condition

Fede · 05/17/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?

Thanks in advance!

Fede

Andrée Starå · 05/17/19

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

Fede · 05/17/19

Hi Andree'!

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

Cheers,

Federico

Paul Newcome · 05/20/19

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

Fede · 05/21/19

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

Andrée Starå · 05/21/19

Happy to help!

I saw that Paul answered already!

Let me know if I can help with anything else!

Best,

Andrée

Paul Newcome · 05/21/19

Happy to help!

SUMIF condition

Comments

Help Article Resources

Categories