Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Batty
 
Posts: n/a
Default Count the occurance of a value x a value in another cell in excel

How do I count the number of times a value appears on a spread sheet and
multiply that number by a value in another column?
  #2   Report Post  
KL
 
Posts: n/a
Default

Hi Batty,

Is this what you are after (?):

=COUNTIF(Sheet2!$1:$65536,"X")*Sheet1!A1

Regards,
KL


"Batty" wrote in message
...
How do I count the number of times a value appears on a spread sheet and
multiply that number by a value in another column?



Reply
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
Excell: count occurance of letters in a column Ispencer Excel Worksheet Functions 1 June 8th 05 05:56 PM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 0 May 15th 05 08:14 PM
Count number of occurences in 1 column only if something in anothe Wenster Excel Worksheet Functions 2 February 7th 05 09:58 PM
Count the occurance of upper or lower case letters Sivsy Excel Worksheet Functions 3 January 13th 05 07:31 PM


All times are GMT +1. The time now is 01:12 AM.

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

About Us

"It's about Microsoft Excel"