LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
STK
 
Posts: n/a
Default Subtotaling on column with IF statement results

I created a spreadsheet with one column having an IF statement - it
calculates how much we should re-order per store based on what was sold.

I asked it to subtotal for each store - the formula appears in the cell, but
it does not calculate the subtotal. I tried saving the column as the values,
but it still does not subtotal. When I typed in the numbers, it DID
subtotal. What do I need to do so it will subtotal?

Thanks for your help.
--
STK
 
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
pivot table results - with value in every row and column PivotMan Excel Discussion (Misc queries) 3 February 15th 05 08:27 PM
Subtotal results in new column and then sorting subtotals ArtM Excel Worksheet Functions 1 January 18th 05 12:21 AM
IF Statement with Average Function results in #Value! Paul Excel Discussion (Misc queries) 5 December 28th 04 08:11 AM
i am using an if statement to sum a row with a column and i'm off. twig Excel Worksheet Functions 1 November 23rd 04 10:07 PM
adding if statement results Robb27 Excel Worksheet Functions 3 November 20th 04 05:27 AM


All times are GMT +1. The time now is 10:23 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"