extracting totals from within a spreadsheet
I am still confused.
i will try to explain it this way.
If column C is true
and column E is true
and column D is true
then i want the total of column C and and a total for column D
Does that help?
"Peo Sjoblom" wrote:
=SUMPRODUCT(--(A2:A50="x"),--(B2:B50="y"),C2:C50)
will sum C2;C50 where A2:A50 is "x" AND B2:B50 is "y"
adapt to fit your requirements
if you have excel hours you might want to use a custom format of [hh]:mm or
else it will start anew after 24:00
--
Regards,
Peo Sjoblom
"Jovetta" wrote in message
...
I need to know how to take different information from within a spreadsheet
--where two conditions/catogories must apply so that a third column where
i
have inputed hours, will total for those conditions only... can anyone
help?
|