| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF across worksheets
Is is possible to use sumif on one worksheet and then point to another
worksheet within the same workbook? Example: sumif(Sheet1!A:A,A2,Sheet1!B:B) When I do this it does not give the correct sum and when you click in the formual the range and sum range both have #NUM next to it |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| Sumif across multiple worksheets | Excel Worksheet Functions | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| SUMIF across a range of worksheets | Excel Worksheet Functions | |||
Threaded Mode
