SUMIF condition
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
Comments
-
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.
-
Hi Andree'!
Thanks for picking this up! unfortunately it is not working... please see the screenshots.
Cheers,
Federico
-
Remove the VALUE function from your SUMIF formula but leave it on the RFQ Sent - RFQ Received formula.
-
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
-
Happy to help!
I saw that Paul answered already!
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.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!