Add a column where
=sumproduct(--'spreadsheetname'!A2:a5500="dfw"),--('spreadhsheetname'!H2:h5500="attempt
to address charge"),'spreadhsheetname'!I2:I5500)
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Tammy" wrote in message
...
Hi there -
I need to sum up column I of my spreadsheet sheet where column A contains
DFW and column H contains Attempt to Address Charge.
Can I use something like this?
=sumproduct(--'spreadsheetname'!A2:a5500="dfw"),--('spreadhsheetname'!H2:h5500="attempt
to address charge"))
any help appreciated.
thank you!
|