How to SUMIF using two sheets?

mmmagcale

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?

Paul Newcome

@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

You would use something like this:

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

NikkiOno

@Paul Newcome

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.

Paul Newcome

@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(………..)

NikkiOno

@Paul Newcome that worked!