Help with SUMIF and two columns

S

Sean

Hi there,

I'm tring to use Sumif to look in two different columns and retrieve data in
a if both columns contain what I am looking for. For example

A B C
Travel Jan 350
Travel Jan 25
Salaries Jan 50
Travel Feb 150

What formula can I use to tell me what the total Travel for January is? Any
help that can be offered would be appreciated.
 

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

Formula help needed please 2
Vlookup doesn't work: results are wrong 2
multiple SUMIF help/advice 3
Month wise Sum 4
Group Total 2
SUMIF with multiple criteria 5
Linking two worksheets 3
Trying to check 2 columns for text and add a 3rd col to total 1

Top