Thread
:
Subtracting based on 2 conditions
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Subtracting based on 2 conditions
Hi,
Am Wed, 10 Sep 2014 12:51:14 -0700 (PDT) schrieb
:
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.
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,Shee t1!C5:C40-Sheet1!D5:D40))
and enter the array formula with CTRL+Shift+Enter
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch