extracting totals from within a spreadsheet
=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?
|