| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM calculations with multiple criteria
I designed a formula: =SUM(($E$1:$E$49, "")*($G$1:$G$49, "5A")) This worked
at first, but when I increased the range size from 49 to 258 it won't work now. I have checked my formatting and can't come up with an answer. I am trying to find the # of blank cells in column E by unit - column G - (5A, etc) for a large range. Any help would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Multiple Calculations in a Formula | Excel Discussion (Misc queries) | |||
| using multiple worksheets to do calculations | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
