| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL COUNT of text
I have an excel file with a location code in col A (in text) and attendence
(marked as F, H, or A) in cols E-I (corresponding with days of the week). Each row is a person. I need to count each type of attendence for each type of code for the whole sheet. I've been screwing around with ifs, ands, sums, sumproducts. I must be making it harder than it really is . . . . |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL COUNT of text
This gives count of "F"'s that have a corresponding code of "A"
=SUMPRODUCT((A1:A5="A")*(E1:I5="F")) Adjust range sizes as needed. I assumed you wanted a count of each attendance regardless of what dat it was. For each day, simply limit the width of the second array. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sbrogins" wrote: I have an excel file with a location code in col A (in text) and attendence (marked as F, H, or A) in cols E-I (corresponding with days of the week). Each row is a person. I need to count each type of attendence for each type of code for the whole sheet. I've been screwing around with ifs, ands, sums, sumproducts. I must be making it harder than it really is . . . . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL COUNT of text
=countif(E:I,"F")
would count the number of F's in columns E:I sbrogins wrote: I have an excel file with a location code in col A (in text) and attendence (marked as F, H, or A) in cols E-I (corresponding with days of the week). Each row is a person. I need to count each type of attendence for each type of code for the whole sheet. I've been screwing around with ifs, ands, sums, sumproducts. I must be making it harder than it really is . . . . -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CONDITIONAL COUNT of text
that far I got, but then got stuck trying to get the subtotals by the code in
column A. Luke's answer above does it, though, I just never had the syntax quite right. "Dave Peterson" wrote: =countif(E:I,"F") would count the number of F's in columns E:I sbrogins wrote: I have an excel file with a location code in col A (in text) and attendence (marked as F, H, or A) in cols E-I (corresponding with days of the week). Each row is a person. I need to count each type of attendence for each type of code for the whole sheet. I've been screwing around with ifs, ands, sums, sumproducts. I must be making it harder than it really is . . . . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
| conditional count | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Hybrid Mode
