Excel sum if then?

New Contributor

I am looking to do a sum of the answers in Col M without using Col M.  Do-able?



5 Replies
Something like this should work:

@mtarler   When I use the columns, it works.  However, when I use only the rows I need, it brings back #VALUE!

maybe you could share the actual formula or better yet the worksheet (no confidential info). You need to make sure if you ref only a set of rows that all references include the same number of rows

@mtarler   Attached file - thanks!

Why are there '@' symbols in there?
Got rid of those '@' symbols and it worked fine.
the '@' symbol is used to force only 1 item to return so for example in a table you might want only use the cell in the same row as the formula so you use [@Colx] because [Colx] would refer to the entire column.
That all said, what version of Excel are you using?