| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumifs in Excel 2007 for only numerical values
Hello,
How can I write a "Sumifs" formula in Excel 2007 which sums only if the range of a criteria contains numbers? Example: if sum cells b2:b8 only if cells a2:a8 contain numbers. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 -- SUMIFS v SUMPRODUCT | Excel Worksheet Functions | |||
| Sumifs formula in Excel 2007 | Excel Discussion (Misc queries) | |||
| sumifs formula in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 - SUMIFS formula use between tabs | Excel Discussion (Misc queries) | |||
| Excel 2007 SUMIFS | Excel Worksheet Functions | |||
Threaded Mode
