SUMIF in a given month

[maztaz]

I need to sum totals owed for a given month. I can do a SUMIF if I have separate columns for day of week, date,month, year but it is messy. I can't seem to do the same thing if the one column is formatted to Date with the same info. I know there's a simple way - maybe it has to be a certain format to work. Hope you can help.

[vandanavai]

Hi

See if this helps u.

Assume Dates are enterd in column A (A1,A2,A3.....)
In cells "B1","B2".... enter formula =month(A1)
Say in cells"C1", "C2"... amount is entered.

In cell "D1" enter following formula
=SUMIF(B1:B3,"=4",C1:C3) , This will give total for April as 4 represents April. For May enter 5, and so on.

Bye

[maztaz]

I tried to follow instructions but entering the formula =MONTH(A1) gives me
1st Jan 1900. I'm obviously not getting it. The sumif formula looked like it should work and I had tried something very similar without the 'MONTH' formula in the other cell. Have taken out the =MONTH formula and have attached an example of what I want to do. (At least I tried to upload it. Not sure if that's how you do it) Hope this helps

[VBA Noob]

Try


=SUMPRODUCT(--(TEXT($B$3:$B$200,"mm/yy")="08/07")*($E$3:$E$200))

VBA Noob

[maztaz]

Thankyou for that. I've got a bit closer but it's not returning the right answers yet. Needs a bit of tweeking. I'll keep you posted . thanks again.

[maztaz]

Tahnkyou so much. I've changed the range in the last part of the formula and it's doing the trick.

[VBA Noob]

Good to here.

PS. Make sure both ranges are the same

VBA Noob