=SUMPRODUCT(((Data!$H$2:$H

and exactly the same for D2 except with added sum range

=SUMPRODUCT(((Data!$H$2:$H

see attached

regards, barry

26909642.xlsx

Solved

Posted on 2011-03-24

I need an excel formula to correctly count a total number and a total length amount (please see the attached file).

What I am trying to do is:

1. Count a total number that has dates in either Column H (Signed), Column I (Closed Date) or Column M (Approval) for a specific date range (See the Info tab Columns A and B). I need to make certain that it only counts it as one if there is a date in 3 of 3 places or 2 of 3 places.

2. I am also trying to sum up the amount that is in Column J (Actual Length) on the info tab, if there is a date in either Column H (Signed), Column I (Closed Date) or Column M (Approval). I need to make certain that it only adds the length one time, not 3 times.

I am trying to use a formula that I got here, only messaged to this particular issue, only its counting something way wrong. The Info Tab has the formulas. The data tab has the, well , data.

3-24-11.xlsx

What I am trying to do is:

1. Count a total number that has dates in either Column H (Signed), Column I (Closed Date) or Column M (Approval) for a specific date range (See the Info tab Columns A and B). I need to make certain that it only counts it as one if there is a date in 3 of 3 places or 2 of 3 places.

2. I am also trying to sum up the amount that is in Column J (Actual Length) on the info tab, if there is a date in either Column H (Signed), Column I (Closed Date) or Column M (Approval). I need to make certain that it only adds the length one time, not 3 times.

I am trying to use a formula that I got here, only messaged to this particular issue, only its counting something way wrong. The Info Tab has the formulas. The data tab has the, well , data.

3-24-11.xlsx

2 Comments

=SUMPRODUCT(((Data!$H$2:$H

and exactly the same for D2 except with added sum range

=SUMPRODUCT(((Data!$H$2:$H

see attached

regards, barry

26909642.xlsx

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Title | # Comments | Views | Activity |
---|---|---|---|

Need a macro to create new values based on one value in column A and values in columns B and beyond. | 5 | 29 | |

Boolean help | 6 | 27 | |

Merging-Splitting-Multiple |
33 | 42 | |

Excel VBA When using VLookup | 6 | 26 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**10** Experts available now in Live!