G
Griffey5
Using the =SUM(IF) array Excel can add an array with 2 and conditions such as
(=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")'Batch Log'!F2:F2001,0)) but it cannot add an array
with 3 conditions such as (=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch
Log'!F2:F2001,0))
Why?
(=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")'Batch Log'!F2:F2001,0)) but it cannot add an array
with 3 conditions such as (=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch
Log'!F2:F2001,0))
Why?