Reference a column in another sheet

Andy_DAI
Andy_DAI ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello - 

My company is new to smartsheets but it has ALREADY made a huge difference for us.

I'm playing with functions that reference other sheets and I have a very specific question - 

I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same.  The formula I'm working looks like this:

=SUMIF({Sheet 1 Range 1}, AND({Sheet 1 Range 2} = Date1, {Sheet 1 Range 3} = "CHECK"))

 

Where:

Sheet 1 Range 1 is a column of dollar values being summed

Sheet 1 Range 2 is a column of the deposit dates being compared against Date1

Sheet 1 Range 3 is a column of payment types

 

This is currently returning #INVALID OPERATION, so I'm obviously missing something.

 

Will this work or is there an easier way to do this?



Thanks!

Andy

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!