Desperately Seeking SUMIF

[jdmill80]

Hi Everyone,

I'm new here but thought this would be just the place to get this question answered since my coworkers have been stumped!

I'm trying to do a SUMIF with 2 criteria. Here's an example:

I have 3 columns.

Column A includes one of two years, 2005 & 2006.
Column B includes one of two Names, **** & Jane.
Column C includes random numbers.

How can I say, sum column C if column A equals "2005" AND column B equals "Jane"?

Thanks SOOOOO much gang. I will definitely pass this favor forward if this can be solved.

Thanks!
Jon [/u]

 

[Asala42]

have 3 columns.

Column A includes one of two years, 2005 & 2006.
Column B includes one of two Names, **** & Jane.
Column C includes random numbers.

How can I say, sum column C if column A equals "2005" AND column B equals "Jane"?

That's our buddy SUMPRODUCT

=SUMPRODUCT(--($A$2:$A$100=2005),--($B$2:$B$100="Jane"),$C$2:$C$100)

 

[Brian from Maui]

Hi Everyone,

I'm new here but thought this would be just the place to get this question answered since my coworkers have been stumped!

I'm trying to do a SUMIF with 2 criteria. Here's an example:

I have 3 columns.

Column A includes one of two years, 2005 & 2006.
Column B includes one of two Names, **** & Jane.
Column C includes random numbers.

How can I say, sum column C if column A equals "2005" AND column B equals "Jane"?

Thanks SOOOOO much gang. I will definitely pass this favor forward if this can be solved.

Thanks!
Jon [/u]

If you don't have true date values in column A but merely 2005 & 2006

=SUMPRODUCT(--(A2:A100=2005),--(B2:B100="Jane"),C2:C100)

Edit,

Correcting the formula

 

[jdmill80]

THANK YOU!!!

 

[Brian from Maui]

Correction on the formula,

=SUMPRODUCT(--(A2:A100=2005),--(B2:B100="Jane"),C2:C100)