Arrays

[Will]

Can you use an AND argument in an array?

I want to equate two columns and then sum the item in
third column if it meets the two criteris.

I.E. SUM all entries in Column C that have 1234 in column
A and 6789 in Column B.

Thanks,

Will

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000=1234)*(B1:B1000=6789),C1:C1000)