LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mulder149
 
Posts: n/a
Default need some help on the right function to use..

Well also if it is even possible to do this. But for example lets say I have
a list of assets and I need to know over all how many times I use and asset
for plan A or plan B, in Column "C" of my spreadsheets I have the asset 1 to
35, and in column "F" I have if I used them for plan A or B, now the tricky
part is I would like to keep a running total on a different sheet, so in
theory I need something to look down through my sheets and validate the two
different responses A or B for each asset and distribute them to a different
cell. So basically I want to ad up all of the A's and the B's for each
asset and keep a running total for the year. I have every end covered except
how to get excel to look at the asset number and count each A or B and keep a
running total of each A or B in a particular cell. I hope this question
isn't to long. forgive me.

Nate

 
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
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


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