| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Function
I am trying to write a SUMIF formula where the "Criteria" is any cells in the
range that have a date in them. and in another formula any cells in the range that are blank. IE =SUMIF(h5:h100,Criteria to = any cell with a date value,g5:g100) and =SUMIF(h5:h100,Criteria to = any blank cells,g5:g100) any help would be GREATLY appreciated!! also I need to write a formula in cell I3 that says if Cell H3 has a value enter "X" in I3, if H# has NO value put a "Y" in I3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| How do I use the TODAY function with the SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Can SUMIF function include AND function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
