View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jc9972003@yahoo.com is offline
external usenet poster
 
Posts: 38
Default Subtracting based on 2 conditions

On Wednesday, September 10, 2014 2:51:14 PM UTC-5, wrote:
Please help me: On column C5:C40 I have Tickets resolved i.e (10,30,50)etc on column D5:D40 I have Major Outages i.e (3,2,1) On Column C4 The header is Tickets Resolved On Column D4 The header is Major Outages and on B5:B40 I have agent names. The Month name I can have anywhere on sheet. on a Separate sheet I need to Subract Major Outages from Tickets resolved based on Name and Month Can someone please help??




Thank you Clause that works like a charm, your always very helpfull.