Value based on multiple conditions
 

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!

Value based on multiple conditions
 

If I understand the question right,

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

just an example.

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

Value based on multiple conditions
 

Oh course, the AND option! Thank you!

Now does that work with a SUMIF also?

"Gaurav" wrote:

If I understand the question right,

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

just an example.

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

Value based on multiple conditions
 

Now does that work with a SUMIF also?

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---