# Formula help (SumIf totals caculations COMPLETELY LOST!)

1. ## Formula help (SumIf totals caculations COMPLETELY LOST!)

So, taking the easy way out came around to bite me in the butt. I had someone help me with the formulas for this excel sheet, now I need to make a change, and have no idea how to do it.

Hopefully the sheet is pretty self explanatory but basically I need to subtract the 1099 column for each month (H24:H200) from the commission totals for each month (F2:F13) and place that value in a new column under TOTAL NET COMMISSIONS G2:G13

For example, in October, there were two 1099 entries (\$1,467.00 & \$1,500.00)

I need to add up the total 1099 value for each month and then subtract it from the month's total commission.

Geez... I am rambling. If anyone has a clue as to what I need please help, or point me in the right direction! Thank you so much in advance! File attached.

Attachment 435517

2. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

I may have missed the point but I just added two columns - see attached sample.

3. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

If you wanted it all in the one column, then try this in cell F11:
``Please Login or Register  to view this content.``

4. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

Originally Posted by tuph
I may have missed the point but I just added two columns - see attached sample.
This would work, however for "ADJUSTED COMMISSIONS" it is showing \$0.00 for any month without a "1099" value. Is there a formula I can put in there that doesn't depend on a value for 1099 but still calculates the ADJUSTED COMMISSIONS.

I tried putting in 0 for all the 1099 that didn't have any and it still showed \$0.00 for the ADJUSTED COMMISSION

5. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

Originally Posted by Beamernsw
If you wanted it all in the one column, then try this in cell F11:
``Please Login or Register  to view this content.``
That worked perfectly, however, I'm now realizing seperated columns would be best "TOTAL COMMISSIONS", "TOTAL 1099", and "NET COMMISSIONS" so I can see exactly how much went to 1099 each month. It's the Months that mess me up. I can handle equations dealing with x to y but when i need to calculate the values based on months I'm lost. Even studying the equations, it's all greek to me!

THANK YOU SO MUCH FOR RESPONDING THOUGH!

6. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

In that case, use tuph's example and paste this formula into cell H2 and copy down:

``Please Login or Register  to view this content.``
Instead of 0.00 if G2 is blank, it uses the value of cell F2.

7. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

Originally Posted by Beamernsw
In that case, use tuph's example and paste this formula into cell H2 and copy down:

``Please Login or Register  to view this content.``
Instead of 0.00 if G2 is blank, it uses the value of cell F2.
THIS WILL WORK! lol thanks so much for contributing! Now when I have some free time, I promise I will try to learn WHY this all works.

Thank you again everyone!!! It has been solved!

8. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

you're most welcome

9. ## Re: Formula help (SumIf totals caculations COMPLETELY LOST!)

Happy to be of assistance.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1