Formula help please

[nip]

Excel 2007
need a formula to look in column A and see a word then add up
associated numbers in column B from row 10 to 45 and in colum B cell
46 * the total by 5%
reworking an invoice to comply with GST and HST entries.
thanks

 

[nip]

Excel 2007
need a formula to look in column A and see various entries assiciated by name, add up
amounts assoicated to any entries in column B from row 10 to 45 and in colum B cell
46 * enter the total and times by 5%
reworking an invoice to comply with GST and HST entries.
thanks

Also need the ability to add more than one province ie: Alberta,
Sask, Manitoba all 5%

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Excel 2007
need a formula to look in column A and see various entries assiciated by
name, add up
amounts assoicated to any entries in column B from row 10 to 45 and in
colum B cell
46 * enter the total and times by 5%
reworking an invoice to comply with GST and HST entries.
thanks

Also need the ability to add more than one province ie: Alberta,
Sask, Manitoba all 5%

 

[Fred Smith]

You probably want Sumif, as in:
=sumif(a10:a45,"word",b10:b45)*5%

Regards,
Fred

 

[Fred Smith]

Now use Vlookup for the province.
=sumif(a10:a45,"word",b10:b45)*vlookup("Alberta",sheet2!a1:b10,2,false)

Regards,
Fred

Excel 2007
need a formula to look in column A and see various entries assiciated by
name, add up
amounts assoicated to any entries in column B from row 10 to 45 and in
colum B cell
46 * enter the total and times by 5%
reworking an invoice to comply with GST and HST entries.
thanks

Also need the ability to add more than one province ie: Alberta,
Sask, Manitoba all 5%