One way:

=SUMIF(C1:C100,"<",A1:A100)


In article ,
JamieWPS wrote:

I am trying to make a formula to get the following results:
If a date/text is entered into a cell in Column C, then the corresponding
cell data in Column A will add to a running total on the bottom of Column C.

So if A3, A4, and A5 have numbers in them (ie. A3=15, A4=10, A5=30) and a
date or text is entered into C3 and C4, then the total at the bottom of
Column C would add only the numbers from A3 and A4.

I tried to do a SUMIF formula but it won't pull the numbers because I am not
sure how to set up the condition. I am not even close to being savvy with
Excel, so please walk me through any possible formulas. Thank you.