sumif for multiple sheets in workbook

F

Fritzi

I am trying to get a sum for a particular item in a workbook. There are 43
sheets in the workbook. I was doing sumif and it says the formula is too long
and I was on sheet 40. Any ideas on how to get it to pull the info I need
from multiple sheets?
 
P

Paresh

I am trying to get a sum for a particular item in a workbook. There are 43
sheets in the workbook. I was doing sumif and it says the formula is too long
and I was on sheet 40. Any ideas on how to get it to pull the info I need
from multiple sheets?
Click to expand...

I think, you are talking about excel spreadsheets. If yes, then this
is not the right froup for MS Excel related stuff.

Thanks,
Paresh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf from multiple sheets in another workbook 4
Sumif apllying to all sheets in workbook 2
Dsum and Dmax with structured references 1
VBA for Dependents shortcut menu 0
SUMIF over multiple spreadsheets 4
How To Rapidly Copy Formulas? 0
Couple subs need help with 2
Multiple Columns in Sum Range using SUMIFS 1

Top