Summing two columns with conditions?

[Sippy69]

Hey all, I could use some Excel genius help.

I want to sum two columns with one of these columns having a certain criteria.
I need to sum column A if it contains a "Y", and column E if the date is greater than 9/8/08.

I have attached a screenshot of the file. It's over 2m so I can't upload the entire file.

Any thoughts?

Thanks in advance.

[arthurbr]

try =sumproduct((a1:a1000="y")*(e1:e1000>09/08/08))

change the ranges to fit your needs

[Sippy69]

Arthur,
Thank you for the quick response but this one didn't work.
I changed the ranges to what I needed but the formula returns an "#n/a".

I have the results on a seperate worksheet and here's the formula I revised from yours. I tried putting the date in quotes and changing the date to 39699 but this also didn't work.

=SUMPRODUCT(('Install log'!A2:A10000="Y")*('Install log'!E2:E10000>39699))

Any thoughts?

[arthurbr]

Are your dates really dates or text looking like dates? Formula works for me
Just to make sure, please post a small sample of your data ( as an xls file so it can be worked upon)

[Sippy69]

Arthur,

I have attached a smaller sized worksheet for you to view.
The dates in column E are a result of a vlookup referencing another sheet, but the cells are formatted to display dates of 39699 (9/8/2008).
Could this be confusing the formula?
The attachment I provided does not show the vlookup function I have setup in column E.

I did try this formula in the test file I have attached and the formula worked on this sheet with one exception. I went and changed the date in E2 to reflect 7/8/08 and the total did not change.

What I would like to do is have three seperate results for my management. The first result is the total number of systems installed since 9/8/08 with using column A to sum the Y's if they have been installed on or after 9/8/08.

The second result is the total number of systems installed with a PA report, and the third result is the total number of systems w/o a PA report.

I have figured out how to do the 2nd & 3rd results, it's just the first result I need this formula for.