Frequency Formula
In Column B I have listed various product codes, these codes are a mixture of
both alpha and numerical characters, some are duplicated several times in the column. Each product code has an associated payment total in £ sterling in Column I. I would like to place a formula in Column K which will show the associated payment 'total' for each product code. There is not a column containing unique values within the spreadsheet. |
Frequency Formula
Hi,
you posted the same question a few days ago I've answered it already "SiH23" wrote: In Column B I have listed various product codes, these codes are a mixture of both alpha and numerical characters, some are duplicated several times in the column. Each product code has an associated payment total in £ sterling in Column I. I would like to place a formula in Column K which will show the associated payment 'total' for each product code. There is not a column containing unique values within the spreadsheet. |
Frequency Formula
Take a look SUMIF function in Excel help menu
"SiH23" wrote: In Column B I have listed various product codes, these codes are a mixture of both alpha and numerical characters, some are duplicated several times in the column. Each product code has an associated payment total in £ sterling in Column I. I would like to place a formula in Column K which will show the associated payment 'total' for each product code. There is not a column containing unique values within the spreadsheet. |
All times are GMT +1. The time now is 02:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com