Multiple criteria for a "sumif" function

[Stickman]

Have been trying to write a formula which would do the following:

Scan column A and see if the month of the date shown matches a given
month;
if so, then scan column B and see if the entry is equal to "interest";
if so, then sum the appropriate values in column C

Problem #1: can you insert multiple criteria and, if so, how?
Problem #2: the data in column A are dates. But using the funtion
"MONTH(A:A)" doesn't work. What do you do?

Many thanks in advance for any help.

 

[Stickman]

So, what you are saying, is that you got creative on me! )

Many thanks.

G

 

[Ken Wright]

LOL - Sumproduct can be expanded to accommodate numerous criteria, and with a slight tweak can be
used to simply count data that meet the specified criteria, eg if you remove the last section of
the example quoted, you will be left with simply a count of all the rows where A9:A20=A1 and
B9:B20="A"

=SUMPRODUCT((A9:A20=A1)*(B9:B20="A"))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
There's no 'I' in 'Team'
----------------------------------------------------------------------------

So, what you are saying, is that you got creative on me! )

Many thanks.

G

<snip>