>=date

[excelFan]

please help,
the formula
sumif(mDate,A1,account), works fine (A1 is a date cell), but it fails when
become
sumif(mDate,>=A1,account) or sumif(mDate,">=A1",account) or even when use a
name for A1 like sumeif(mDate,>=period,account).
many thanks for your help

 

[Frank Kabel]

Hi
use:
sumif(mDate,">=" & A1,account)

 

[excelFan]

Many thanks
Frank Kable
just work excellent.

Hi
use:
sumif(mDate,">=" & A1,account)