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

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...

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

See if this helps:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"jettp" wrote in message
...
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...

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

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?

"Anne Troy" wrote:

See if this helps:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"jettp" wrote in message
...
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...