ExcelBanter - can i create formula giving totals based on financial & text info

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can i create formula giving totals based on financial & text info (https://www.excelbanter.com/excel-discussion-misc-queries/45358-can-i-create-formula-giving-totals-based-financial-text-info.html)

can i create formula giving totals based on financial & text info

Am i able to create a formula that gives me monetray totals for expenditure
on hotels, split into totals for 6 varying business sectors?

All times are GMT +1. The time now is 02:56 PM.