Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |