|
|
#1
02-06-2018, 05:56 AM
|
|||
|
|||
Auto Sum calculate the values of rows that are hidden ...
I have the first row with auto sum function to calculate the (Total Invoice Value) which is in column "H".
There are hundreds of invoices with details. So, when I want to filter any one invoice, say, Invoice No. 1550 (Which has 10 rows with 10 item details), the Total Invoice Value is showing the sum of whole column not of just these 10 rows. How to resolve this issue? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Auto populate & auto calculate values from other sections in the same word document
|
Frantic | Word VBA | 2 | 01-24-2015 04:54 PM |
|
VBA to keep hidden rows hidden when filtering
|
tectonicseer | Excel Programming | 1 | 07-27-2014 11:54 AM |
| add values to dropdown selections and calculate | guyhs | Word | 7 | 10-24-2012 05:11 PM |
|
hidden rows
|
gsrikanth | Excel | 5 | 01-19-2012 02:40 PM |
| calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Windows 7 32bit 
Office 2003
Threaded Mode