Carrying Balance from Worksheet to Worksheet

D

dpeolewis

New Member
Joined
Aug 31, 2011
Messages
1
I'm brain-dead at this point of the day:confused:. I have a form that has several "if, then totals" at the bottom. I need to take those total VALUES to the next spreadsheet along with the spreadsheet continuing to calculate the "if, then totals"
Here's the formula that I currently am using:
=SUMIF(F4:F28,"=CA",D4:D28)+SUMIF(F4:F28,"=CA",E4:E28)
then when I go into the next worksheet I need to continue to use this formula plus add the VALUE from Worksheet 1

Thanks for any help anyone can provide!!
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
You must log in or register to reply here.

Similar threads

Y
  • Solved
Wrong Copy Data from Several Excel file
Replies
8
Views
348
yamixas
Y
J
  • Question Question
formula to match cell on current worksheet to a cell in an array on a different worksheet, and then display value of cell in same row of array
Replies
2
Views
250
Jmoz092
J
C
  • Question Question
Print from database
Replies
0
Views
278
Charlreena
C
A
  • Question Question
Excel - looking up data with multiple criteria from table/array, date must be same or nearest before the target cell
Replies
8
Views
612
Peter_SSs
Peter_SSs
R
  • Question Question
Freezing/Logging Data from DDE at 1 Minute Intervals
Replies
1
Views
62
Anthony47
A

Forum statistics

Threads
1,224,586
Messages
6,179,722
Members
452,939
Latest member
WCrawford

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top