Subtracting based on 2 conditions

  • Thread starter Thread starter jc9972003
  • Start date Start date
J

jc9972003

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??
 
Hi,

Am Wed, 10 Sep 2014 12:51:14 -0700 (PDT) schrieb (e-mail address removed):
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.
Click to expand...

your month names in column A and the expected month name and agent name
in the seperate sheet in G1 and H1 then
=SUM(IF(Sheet1!A5:A40&Sheet1!B5:B40=$G$1&$H$1,Sheet1!C5:C40-Sheet1!D5:D40))

and enter the array formula with CTRL+Shift+Enter


Regards
Claus B.
 
Hi,

Am Thu, 11 Sep 2014 09:33:01 +0200 schrieb Claus Busch:
=SUM(IF(Sheet1!A5:A40&Sheet1!B5:B40=$G$1&$H$1,Sheet1!C5:C40-Sheet1!D5:D40))
Click to expand...

you can do it also with a Pivot table


Regards
Claus B.
 
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 headeris Tickets Resolved On Column D4 The header is Major Outages and on B5:B40I 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??
Click to expand...



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