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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Function
It depends. If your column is only dates or blanks, then all dates can be found using the criteria
"0" =SUMIF(H5:H100,"0",G5:G100) And the reverse can be =SUMIF(H5:H100,"",G5:G100) Finally, in cell I3, use the formula =IF(H3<"","X","Y") HTH, Bernie MS Excel MVP "noodlehounds" wrote in message ... 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 |
Reply |
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 |