1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 2007 - Conditional SUM formula problem

Discussion in 'Business Applications' started by greigorius, Jan 12, 2011.

Thread Status:
Not open for further replies.
  1. Keebellah

    Keebellah Hans Trusted Advisor

    Mar 27, 2008
    I did some coding a reproduced your Reulsts screen in the form of the pivot table.

    Just double click on cell B1 of Sheets Results to refresh.

    Condition is that the Data sheet starts on row 6 with first entry on row 7 or 8 as is now.
    It was just fun to do.

    The table will expand or reduce denpending on the number of month's and therefore also the text in the last column

    8-months 6-months whatever applies.
    It was just fun to do, and like I say, I like the 'brain gymnastics' ;)

    Attached Files:

  2. etaf

    etaf Wayne Moderator

    Oct 2, 2003
    nice work - i notice on the original OP example he grouped the codes and sub-totalled - been playing to do that in a pivot and not so easy on the grouping
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/974188