Quick Excel formula question?
help! want to count a #'s occurance in a table. have a 5x4 grid of SnG finishes (1-9), and a cell that counts how many 1sts.
COUNT(A1:D5) returns how many of those have a value. i want a COUNT(IF(1,A1:D5)) or something like that? THat MS paperclip hates me. Hope this is a one line answer from somone who didnt mind my not doing a search [img]/images/graemlins/crazy.gif[/img] thanks, BL' |
Re: Quick Excel formula question?
[ QUOTE ]
help! want to count a #'s occurance in a table. have a 5x4 grid of SnG finishes (1-9), and a cell that counts how many 1sts. COUNT(A1:D5) returns how many of those have a value. i want a COUNT(IF(1,A1:D5)) or something like that? THat MS paperclip hates me. Hope this is a one line answer from somone who didnt mind my not doing a search [img]/images/graemlins/crazy.gif[/img] thanks, BL' [/ QUOTE ] Hi BL I Think this is what you are looking for.... =COUNTIF(A1:D5,1) Regards Mack |
Re: Quick Excel formula question?
=COUNTIF(A1:D5,1)
Perfect! THanks bud [img]/images/graemlins/smile.gif[/img] |
All times are GMT -4. The time now is 04:31 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.