Welcome!

SUMIFS, multiple sheets??

Hello,

I'm trying to add amounts together from different sheets based on certain criteria. I have my data divided up across multiple sheets because it is more than 500 rows. Is this possible? If so, how do I do this?

My formula for a single sheet is: =SUMIFS({Dollar amount}, {Worksheet Range 1}, $ColC$14, {Worksheet Range 2}, ColA15, {Worksheet Range 3}, >=$Dates$1, {Worksheet Range 3}, <=$Dates$2)

I need the {Dollar amount} from multiple sheets.

Find more posts tagged with

Comments

L_123

the only way i know how you can do this is use sumifs()+sumifs()

Mike Wilday

I agree with L@123. You can add the sumifs statements together to get a complete total, But I would probably create a sheet to gather the data from each of the sheets for ease of use (Smaller formulas to maintain, easier to troubleshoot, etc,) and then sum the columns you have them all pulling in the data.

Andrée Starå

Hi,

I agree with Mike and recommend collecting everything in a master metric sheet. It makes it easy to calculate and use the data in dashboards and similar if that need arises.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I suggest using the SUMIFS on the original sheets and then cell linking those totals to a metrics sheet where they can then be summed. This will help avoid the issue of too many cells from other sheets being referenced.

Sign in to join the conversation!

Quick Links

Trending discussions

Slow loading
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?