Help with sumif multiple criteria

[Juls5150]

Here is the formula I am trying to enter;

=SUMIF((O6:O173,"><",0),(O6:O173,"05/15/11",M6:M173))

I am only good with easy formulas! I am trying to sum totals in column M and place that sum in one cell if column O (where I put the date) is blank, or the sum of column M in another cell if column O has a date of 05/15/11.

Can anyone help me out?? I would appreciate any help I can get...trying to get this spreadsheet working in a hurry!

 

[VoG]

Try

=SUMPRODUCT(--(O6:O173<>,0),--(O6:O173="05/15/11"+0),M6:M173)

 

[Aladin Akyurek]

Here is the formula I am trying to enter;

=SUMIF((O6:O173,"><",0),(O6:O173,"05/15/11",M6:M173))

I am only good with easy formulas! I am trying to sum totals in column M and place that sum in one cell if column O (where I put the date) is blank, or the sum of column M in another cell if column O has a date of 05/15/11.

Can anyone help me out?? I would appreciate any help I can get...trying to get this spreadsheet working in a hurry!

Are you looking for two separate formulas:

=SUMIF(O6:O173,"=",M6:M173)

=SUMIF(O6:O173,"05/15/11",M6:M173)

or something else?

 

[Juls5150]

VoG; Thanks for your response...I copied and pasted your formula into a copy of my worksheet, but it gives me an error...any clues?

 

[VoG]

What is the error message?

 

[Juls5150]

Aladin; I am trying to do two different formulas, but in the same cell. My spreadsheet is a list of invoices billed in one column, total due our suppliers in the next column, the balance due coming to us in the next column, and expected pay date (I use the 1st, 5th, 10th, etc.) in the next column, and at the bottom of the spreadsheet, I want to see totals for the balance coming to us next to each date. Once it is paid, I put the same date as expected due date in column O so that at the bottom, next to the due date of 5/15/11, I show 2 totals, those that were already paid on 5/15/11 and in the next cell, the totals that have not been paid and column O is still blank. Does that make any sense? Thanks for your response...I appreciate any help I can get!

 

[Juls5150]

It just says the formula you typed contains an error and directs me to the function menu.

 

[Juls5150]

Here is the formula I am trying to enter;

=SUMIF((O6:O173,"><",0),(O6:O173,"05/15/11",M6:M173))

I am only good with easy formulas! I am trying to sum totals in column M and place that sum in one cell if column O (where I put the date) is blank, or the sum of column M in another cell if column O has a date of 05/15/11.

Can anyone help me out?? I would appreciate any help I can get...trying to get this spreadsheet working in a hurry!

I guess I dont understand this website...I was away from my desk for a few minutes and it "unsubscribed" me....I didnt get any usable answers...is there anyone out there that can help me?? Please see my original message in quote.

 

[Aladin Akyurek]

I guess I dont understand this website...I was away from my desk for a few minutes and it "unsubscribed" me....I didnt get any usable answers...is there anyone out there that can help me?? Please see my original message in quote.

Care to post a tiny sample along with the desired results?

 

[VoG]

Sorry, there was an extraneous comma in my formula. It should have been

=SUMPRODUCT(--(O6:O173<>0),--(O6:O173="05/15/11"+0),M6:M173)