View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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?