How to add one column if 2 other columns have a specific value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to get the sum of column F(Revenue dollars) if column B = Jan,
Feb, or Mar AND column D = YP.

I have tried SUMIF and SUMPRODUCT, but can't figure it out...
 
Anne, this was helpful in adding column B for one month, but I need the
formula for adding column B if it is Month 1, Month 2, or Month 3. Do you
have any other suggestions?
 

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

Offset 2
Excel Help with dates 2
Specify columns to add for months MTD Diff 3
Specify a column by the month to calculate it's data 5
Can I use SUMIF and AND together 4
Determine if a month falls between two dates. 5
Sum Values from different column 1
Unhide column difficulty 3

Back
Top