How to SUMIF using two sheets?

Hello,

I'm having a hard time totaling up numbers in a column in one of my sheets. I only want to add numbers in column "In" that is associated a particular cell ID, in this case, cell ID "49000P" out. Any help is greatly appreciated. What's the formula?

• ✭✭✭✭✭✭

@NikkiOno You would have to do two separate COUNTIFS (one for the sheet with the formula and another for the other sheet) and add them together.

=COUNTIFS(…………) + COUNTIFS(………..)

• ✭✭✭✭✭✭

You would use something like this:

=SUMIFS({Source Sheet In Column}, {Source Sheet Cell ID Column}, @cell = "49000P")

• ✭✭✭✭

I am trying to count the number of cells between two sheets if the date is this current year but keep getting unparseable. this is the formula I'm trying although I've tried a few others that didn't work either. =COUNTIFS([Fitting Scheduled]:[Fitting Scheduled],{date} IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))

I can get it to work when i do each sheet separately but not together. What am i missing?

[Fitting Scheduled]:[Fitting Scheduled] is the first sheet of dates and {date} is the other sheet of dates and I'm trying to add those together in the summary on the first sheet.

• ✭✭✭✭✭✭

@NikkiOno You would have to do two separate COUNTIFS (one for the sheet with the formula and another for the other sheet) and add them together.

=COUNTIFS(…………) + COUNTIFS(………..)

• ✭✭✭✭

@Paul Newcome that worked!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!