Modifying A Sumproduct Formula
I use this formula:
=SUMPRODUCT(--(Sheet1!$Y$4:$Y$60000=Sheet2!$G$4);--(Sheet1!$AB$4:$AB$60000="Directed");--(LEFT(Sheet1!$O$4:$O$60000;3)=$G$5);--(Sheet1!$I$4:$I$60000=Sheet2!E11);--(Sheet1!$AC$4:$AC$60000=$G$3);Sheet1!$N$4:$N$60000 ) In the first criteria (Sheet1!$Y$4:$Y$60000=Sheet2!$G$4), is there a way to ignore the criteria if G4 is blank ? Thank you in advance. |
Modifying A Sumproduct Formula
Try this array formula
=SUM(IF(Sheet2!$G$4="";1;(Sheet1!$Y$4:$Y$6000=Shee t2!$G$4))*(Sheet1!$AB$4:$A B$6000="Directed")*(LEFT(Sheet1!$O$4:$O$6000;3)=$G $5)*(Sheet1!$I$4:$I$6000=S heet2!E11)*(Sheet1!$AC$4:$AC$6000=$G$3)*(Sheet1!$N $4:$N$6000)) -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... I use this formula: =SUMPRODUCT(--(Sheet1!$Y$4:$Y$60000=Sheet2!$G$4);--(Sheet1!$AB$4:$AB$60000=" Directed");--(LEFT(Sheet1!$O$4:$O$60000;3)=$G$5);--(Sheet1!$I$4:$I$60000=She et2!E11);--(Sheet1!$AC$4:$AC$60000=$G$3);Sheet1!$N$4:$N$60000 ) In the first criteria (Sheet1!$Y$4:$Y$60000=Sheet2!$G$4), is there a way to ignore the criteria if G4 is blank ? Thank you in advance. |
All times are GMT +1. The time now is 05:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com