Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif in two columns and in different cells
I'm not sure which function I need to add text "p" and "cps" when this
data is in different columns. The total in this ex: would be p+cps = 2. Any help would be greatly appreciated. I'm new at this. shift class p cps p x p x p x p cps total p+cps = 2 |
#2
|
|||
|
|||
"ferde" wrote: I'm not sure which function I need to add text "p" and "cps" when this data is in different columns. The total in this ex: would be p+cps = 2. Any help would be greatly appreciated. I'm new at this. shift class p cps p x p x p x p cps total p+cps = 2 Assuming that shift is in column A and class is in column b =IF(AND(A2="p",B2="cps"),COUNTA(A2:B2),"") Regards Peter |
#3
|
|||
|
|||
Try this:
=SUMPRODUCT((A2:A100="P")*(B2:B100="cps")) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "ferde" wrote in message ... I'm not sure which function I need to add text "p" and "cps" when this data is in different columns. The total in this ex: would be p+cps = 2. Any help would be greatly appreciated. I'm new at this. shift class p cps p x p x p x p cps total p+cps = 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
count cells across muliple columns | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) |