Add a column where
 

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!

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!

Add a column where
 

Bob - I think it's close - but it's not working. I get an error. Any
suggestions? And is that the correct function to do addition of column I ?


"Bob Phillips" wrote:

=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!

Add a column where
 

You had a couple of errors in your formula that I copied.

Try

=SUMPRODUCT(--(spreadsheetname!A2:A55="dfw"),
--(spreadsheetname!H2:H55="attempt to address charge"),
spreadsheetname!I2:I55)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Tammy" wrote in message
...
Bob - I think it's close - but it's not working. I get an error. Any
suggestions? And is that the correct function to do addition of column I
?


"Bob Phillips" wrote:

=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!

Add a column where
 

thanks! it worked perfectly.

"Bob Phillips" wrote:

You had a couple of errors in your formula that I copied.

Try

=SUMPRODUCT(--(spreadsheetname!A2:A55="dfw"),
--(spreadsheetname!H2:H55="attempt to address charge"),
spreadsheetname!I2:I55)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Tammy" wrote in message
...
Bob - I think it's close - but it's not working. I get an error. Any
suggestions? And is that the correct function to do addition of column I
?


"Bob Phillips" wrote:

=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!