Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2019, 04:54 AM
msnarayanan msnarayanan is offline usage of $ sign Windows 8 usage of $ sign Office 2013
Advanced Beginner
usage of $ sign
 
Join Date: Jul 2015
Posts: 37
msnarayanan is on a distinguished road
Default usage of $ sign

dear sirs

i have a problem in incorporating $ sign in formula

i having a table colum a with (male/female in another columns - department such as
accts mktg etc.
i wanted to find number of males departmen wise:

used the formula =countifs(c$1:c$12,="1",$a1$a12,"=male")

if i copy the forumula in the next raw,it should change to next column keeping
other values in tact.



please guide me as to how i can go about it.

thanks

m s narayanan
Reply With Quote
  #2  
Old 12-14-2019, 02:31 AM
ArviLaanemets ArviLaanemets is offline usage of $ sign Windows 8 usage of $ sign Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Code:
=countifs(c$1:c$12,1,$a1$a12,"male")
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
usage of $ sign What's this sign and how to remove it from my document? Wordfinder Word 10 07-22-2019 01:28 AM
Onenote - euro sign '€ę' instead of ę only Teishu OneNote 1 08-12-2016 05:11 AM
usage of $ sign How to make a sign in sheet? Queenofmycastle OneNote 2 06-29-2015 08:48 AM
usage of $ sign How to sign out from my account when using the outlook? Jamal NUMAN Outlook 5 10-25-2012 10:28 AM
How to sign out from the outlook? Jamal NUMAN Outlook 0 11-21-2010 07:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft