SumIF Cross Sheet

Options

I am simply trying to summarize AR data for a dashboard on a summary sheet. I need to know the balance due for each company totaled up. Below is one of many attempts I have tried. There are only six options so I canmanually update the formaula for each company but that didnt work either. What am I messing up? Thank You


Answers

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Options

    I don't think there is suppose to be an = sign before Company@row. Should look like

    =SUMIF({IBIG Accounts Receivable Range 2},Company@row, {IBIG Accounts Receivable Range 3})

  • IrohGroup1
    Options

    Updated it but still cant get anything but zero?I've tried everything I can think of. I am sure it is something stupid, but cannot figure it out

  • Genevieve P.
    Options

    Hi @IrohGroup1

    Can I clarify what your two ranges are looking at? SUMIF and SUMIFS (plural) have opposite structures. In a SUMIF (singular) statement, the range to SUM goes at the end:

    SUMIF(range, criterion, sum_range)

    In a SUMIFS (plural), then the SUM range is the first one in the list. Can you confirm that your structure is as follows:

    =SUMIF({Company Column}, Company@row, {Column to SUM})


    If this isn't the issue, then it's possible that the formula either isn't finding the criteria (the "Company" is spelled differently between the sheets), or that the SUM range is somehow not seen as Numerical. What type of column is the one that has the balance due? Is there a formula in that column that could be converting your balance into text instead of numbers?

    Cheers!

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!