EXCEL - SUMIF for multiple sheets

0 votes

If another range of cells in each sheet meets the requirements, I must add those cells together. The equation is displayed below.

=SUMIF('sheet0'!D3:Q3; "x"; 'sheet0'!D9:P9)+SUMIF('sheet1'!D3:Q3; "x"; sheet1'!D9:P9)+SUMIF('sheet2'!D3:Q3; "x"; 'sheet2'!D9:P9)

I need to do this for more than 50 sheets, and while this works correctly, is there a shorter formula I can write to achieve the same result?

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 566 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

Pentaho excel input from multiple sheets to textfile

It's possible to use numerous Excel inputs ...READ MORE

answered Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 1,571 views
0 votes
1 answer

Insert formula in multiple excel sheets

To fill across the sheets, you can ...READ MORE

answered Jan 17, 2023 in Others by narikkadan
 • 63,600 points • 406 views
0 votes
1 answer

Can I use multiple domain names for my website?

Well, if you are hosting a website, ...READ MORE

answered Oct 28, 2019 in Others by Barbara
 • 676 views
0 votes
0 answers

How to compare two excel sheets

How to compare two excel sheets , ...READ MORE

Jul 18, 2021 in Others by Sri
 • 3,190 points • 809 views
0 votes
1 answer

How to use next-seo for setting nextjs meta tag with multiple OGP images?

https://github.com/garmeeh/next-seo use this git repo that contains ...READ MORE

answered Feb 24, 2022 in Others by narikkadan
 • 63,600 points • 6,120 views
0 votes
1 answer

Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
 • 63,600 points • 1,417 views
0 votes
1 answer

Excel sumif function with conditions

Try SUMIFS. =sumifs(table1[sum time (sec)],Table1[type],1, Table1[Date],K3, Table1[Time],K4, Table1[Sum Time ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
 • 63,600 points • 547 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 3,974 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
 • 13,690 points • 1,984 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
 • 13,690 points • 975 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.