LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Another sumif question

Thanks to those who answered my previous question.
I have another dilema.... I'm summing up some rows to get cummulative
amounts, now I want to only add if the amount is 0, so if I paid off a loan
and the amount goes down to 0 then it shouldn't at the amounts from the
previous cells.

ex.
cell A1 has the 1000, B1 2000 In cell A2 the total is 1000 in B2 the total
is 1200 but I paid off the 1200 so in C1 there will be 0. How do I still do
cummulative totals in C2 without getting 1200 instead of 0.
--
Ksy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF Question juliejg1 Excel Worksheet Functions 3 January 24th 08 04:23 AM
SUMIF Question juliejg1 Excel Discussion (Misc queries) 2 January 23rd 08 02:32 AM
SUMIF? Question aeddave Excel Worksheet Functions 7 January 23rd 08 12:32 AM
SUMIF question Shan Excel Discussion (Misc queries) 1 December 3rd 06 03:34 AM
Sumif question J Shrimps, Jr. Excel Worksheet Functions 5 January 20th 06 05:26 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"