| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Multiple Pages(Tabs)
I currently use the following formula to add values together from one tab to
a totals page. =SUMPRODUCT(--('1-500'!C4:'1-500'!C518="CY"),--('1-500'!H4:'1-500'!H518="Bus"),'1-500'!G4:'1-500'!G518) But I have added another page (tab) which i need adding into the totals pages as well. The same information is held on this new page and it is held in the same column and rows. How do i adjust the above formula to include the new page? The name page is called 501-1000. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please Help ~ Lookup from Multiple Pages/Tabs Huge Woorkbook.. | Excel Worksheet Functions | |||
| Adding Multiple Excel Spreadsheets To One Another From Saved HTML Pages | Excel Worksheet Functions | |||
| Fomula when adding the same cell across multiple tabs | Excel Discussion (Misc queries) | |||
| Tabs v.Pages | Excel Worksheet Functions | |||
| adding row headings to multiple pages - how do i input the rows? | New Users to Excel | |||
Threaded Mode
