Sumif using dates and positive negative values

E

Eqa

I have past and present dates in column A and Dollar values positive and
negative in col B I want to sum Dollar values that are positive only and are
older than todays date. How do I do this pls.
 
B

Bob Phillips

=sumproduct(--(A2:A200<TODAY()),--(B2:B200>=0),B2:B200)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative value to positive 13
IF Statement accepting only positive values 1
Use TODAY() function as the criteria in a SUMIF formula 1
XIRR Giving Negative Number on Positive Cash Flow Stream 11
Automatic display positive or negative 3
SUMIF evaluating blank DATE data 2
sum visible amounts 2
Excel - Adding positive or negative numbers in a column 5

Top