multiple conditions

E

Ellie Sarmadi

Help pls!
Need a formula to do the following:

if date in range matches date in a cell then sumif function... the
formula doesn't take the if fucntion relating to date in account...

-ellie
 
E

Eduardo

Hi,
suppose that your dates are in column A starting in row 2, the amount to be
sum in column B and the day entered for what you want the sum is in cell C1
so in D1 enter

=SUMPRODUCT(--(c1=A2:A100),B2:B100)

change the range to fit your needs
 
S

Shane Devenshire

Hi,

It would help us if you showed us your formula and what you expect it to do.

In general something like will work just fine:

=SUMIF(A1:A19,D1,B1:B19)

where A1:A19 contains dates and D1 has the date you are looking for, then
sume B1:B19 for the rows where A1:A19 = D1.
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
COUNT IF with unconditional AND on cell dates 4
Excel - Wich Function should I use? 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
IF ARRAY with multiple conditions. 1
Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
Multiple Columns in Sum Range using SUMIFS 1
IF AND Function Date Range Issues 6

Top