Hi All, I have problem with Excel . I have used a SUMPRODUCT to calculate values

Question

Hi All,

I have problem with Excel. I have used a SUMPRODUCT to calculate values for my work for 2013 and 2014 absolutely fine. However when I use the same sum for a range of up to and including 2012 it is not pulling all the data through.

Here are the two that work:

=SUMPRODUCT(('Upgrades and Additions'!AG2:AG810="No")*('Upgrades and Additions'!AA2:AA810=2013)*('Upgrades and Additions'!AR2:AR810))

=SUMPRODUCT(('Upgrades and Additions'!AG2:AG810="No")*('Upgrades and Additions'!AA2:AA810=2014)*('Upgrades and Additions'!AR2:AR810))

The one I have an issue with is the following:

=SUMPRODUCT(('Upgrades and Additions'!AG2:AG810="No")*('Upgrades and Additions'!AA2:AA810<=2012)*('Upgrades and Additions'!AR2:AR810))

I have ensured that the cells it is pulling from are all formatted correctly. There are no N/A's and there is no info to suggest anything otherwise.

Any help woud be greatly appreciated!!!

Explanation / Answer

=SUMPRODUCT(('Upgrades and Additions'!AG2:AG810="No")*('Upgrades and Additions'!AA2:AA810<=(--("2012")))*('Upgrades and Additions'!AR2:AR810))

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects