| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF across a range of worksheets
Hi
I am trying to write a SUMIF formula that will sum across a range of worksheets in a workbook. I never know how many worksheets there will be in this range. The formula I am trying is =SUMIF(Clin1:ClinEND!K:K,NOTES!B8,Clin1:ClinEND!U: U). Can anyone help? If this is not possible using a SUMIF, is there another formula that would work? Thanks Mike |
| 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 | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| Macro with Range of Worksheets | New Users to Excel | |||
Threaded Mode
