SUM Formula

System

This discussion was created from comments split from: Help with SUMIF function with data from another sheet.

Sarita Sah

Hello Community,

I am looking for a formula to return the Sum of criteria "HRIS" from 4 different Smartsheet with 2 criterias (Report name=HRIS and Date in each sheet. Example how many HRIS is planned on July 3rd from 4 different sheets.

Sheet 1- Need count of "HRIS" (Report Name column) which has other terms also, second criteria is count of HRIS on a particular date (date column available in same sheet)

Similarly I have 4 different sheets of different countries. I need count of HRIS (a report name) which due for a particular date from all different 4 sheets. Should I use Countifs or Sumifs, have tried both, but its not working. Please suggest

Paul Newcome

@Sarita Sah It sound like you need a series of COUNTIFS (one for each sheet) added together.

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