Searching across multiple worksheets

J

Jerry Selinger

I have my invoicing set up with Excel. Need to search all invoices for a
total for the Canadian Gst. The total for Gst in each invoice is in cell L2.

Also is there a way to total certain items that I have invoiced. I have
assigned a code number to each unique item. E.G. Labour would be 513. Is it
possible to search across all invoices for code 513 and then total that
amount?

Thanks in advance
 
P

Pranas

Look in the Help for the SUMIF() function. I don't remember exactly
how it works, but it essentually examines one column for the criteria,
in this case "513" and sums the values in another column. Incidently I
think the columns could be ranges. I use it to split out my various
gasoline credit card bills from my mpg list. You know Shell, Exxon,
ARCO(BP), etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching across muliple worksheets 7
Auto filling across multiple worksheets 1
VLookup sum multiple matches 1
Pivot Label Filter in Excel 2007 0
Searching And Summing 1
Summing across multiple columns 1
template creates invoice - how to create summary worksheet? 13
Require formula to search across multiple worksheets 2

Top