| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to count B if C=Bob
I have a spreadsheet with data in column B that I want to show in Column D if
column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#2
|
|||
|
|||
|
Hi
try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#3
|
|||
|
|||
|
Sorry, I may be dense but how does that reference C?
"Frank Kabel" wrote: Hi try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#4
|
|||
|
|||
|
Hi
sorry, maybe I misunderstood you (would be better if you provide some example data). But maybe in D1 =IF(C1="Bob",B1,"") and copy down? -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... Sorry, I may be dense but how does that reference C? "Frank Kabel" wrote: Hi try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#5
|
|||
|
|||
|
Thanks Frank!
I did =COUNTIF(B:C,"Bob") and that worked but I guess I didn't explain my problem correctly. I need the total of the amounts entered in column B when C=Bob not the number of entries. I tried SUMIF but that doesn't make sense... "Frank Kabel" wrote: Hi try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#6
|
|||
|
|||
|
Hi
maybe =SUMIF(C:C,"Bob",B:B) -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... Thanks Frank! I did =COUNTIF(B:C,"Bob") and that worked but I guess I didn't explain my problem correctly. I need the total of the amounts entered in column B when C=Bob not the number of entries. I tried SUMIF but that doesn't make sense... "Frank Kabel" wrote: Hi try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
|
#7
|
|||
|
|||
|
Thanks Frank. It worked like a charm!
"Frank Kabel" wrote: Hi maybe =SUMIF(C:C,"Bob",B:B) -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... Thanks Frank! I did =COUNTIF(B:C,"Bob") and that worked but I guess I didn't explain my problem correctly. I need the total of the amounts entered in column B when C=Bob not the number of entries. I tried SUMIF but that doesn't make sense... "Frank Kabel" wrote: Hi try =COUNTIF(B:B,"Bob") -- Regards Frank Kabel Frankfurt, Germany "JohnT" schrieb im Newsbeitrag ... I have a spreadsheet with data in column B that I want to show in Column D if column C = Bob I tried COUNTIF but can't get it happening. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter and count | Excel Discussion (Misc queries) | |||
| Count occurences between dates | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
