Conditional Formula
 

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.

Conditional Formula
 

Try

=SUMIF(C:C,"<",A:A)



--
Regards,

Peo Sjoblom



"JamieWPS" wrote in message
...
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.

Conditional Formula
 

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.