i have numerous columns that have either a 1.00 or a -1.00 in various cells in that column. What i want to do is at the bottom of that column have the total number of entries that have been made, not just the sum of all the numbers. eg. there are 50 1.00's and 48 -1.00's...what i want is a SUM total that will give me 98, not 2.
Anything against using COUNTA function?
example...you array of data is in A1:E100
Please Login or Register to view this content.
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
could also go with
entered with CTRL+SHIFT+ENTERPlease Login or Register to view this content.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Here's a non array formula
VBA Noob=SUMPRODUCT((ABS(A1:E12)))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks