Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Sum a range based on the status of a check box

Amy Fernadez

HI,

I am in desperate need of formula help. Nothing I try seems to work without getting #UNPARSEABLE

I require a formula to calculate the total of costs based on if another colum is checked.

Prices quotes colum against approved checked colum.

Capture Smartsheet.JPG

Comments

Brent Nathan

try something like:

=SUMIF([Approved by Anthony]6:[Approved by Anthony]7,1,[Price/Quotes ex GST]6:[Price/Quotes ex GST]7)

this would provide the totals for rows 6 and 7, but only if they have been checked off.

Hope that helps!

-Brent

Amy Fernadez

Thank you Brent. Your a lifesaver!!!!