Value based on multiple conditions

E

Eloise

I'm sure this is in the discussion board somewhere already, but I don't have
time to search through it all, so hopefully someone will take pity :O)

I'm working with a data set ("DATA") that has 5 columns and each week I'll
paste in new rows. I will be transferring this data into another sheet
("SUMMARY") that feeds into a comlex "snapshot" page that summarizes all the
data into a more readable format each week.

From the original data ("DATA") in the 5 columns, I'm trying to find out how
to lookup a sum of the values that match three conditions -- name (listed
vertically on summary page), date (horizontally), and EV type (vertically) --
and returns that sum on the summary ("SUMMARY") sheet.

I can imagine an IF statement that would logically go something like this:

if(DATA value = NAME and DATE and EV Type, sum(DATA value), else 0)

Obviously this isn't how Excel works, but that's how my brain thinks of it.
How can I make this happen? I've tried figuring out SUMPRODUCT and INDEX,
but can't make them make sense for my purpose...

Thanks!
 
G

Gaurav

If I understand the question right,

IF(AND(something=something,somethingelse=somethingelse,anotherthing=anotherthing),sum(A1:A100),0)

just an example.
 
M

Max

Now does that work with a SUMIF also?

For equivalent SUMIF, think something simple like:
= SUMIF(Condition1)+SUMIF(Condition2)+ ...
might suffice
 

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

Top