SUM Formula

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
    Paul Newcome ✭✭✭✭✭✭

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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!