Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional formulas
please help!!!!!!!
Column B Column G Barry Y I would like to count how many times these two show together on a row. can this be done? |
#2
|
|||
|
|||
This formula counts how many times the combination of Barry and Y appear in
rows 1 - 5: =SUMPRODUCT((B1:B5="Barry")*(G1:G5="Y")) ---- Regards, John Mansfield http://www.pdbook.com "deaundra" wrote: please help!!!!!!! Column B Column G Barry Y I would like to count how many times these two show together on a row. can this be done? |
#3
|
|||
|
|||
In a helper column, say X, put =b2&G2 and copy down as far as you have data
in B and G Then in Z1 put =countif(X:X,"BarryY") Vaya con Dios, Chuck, CABGx3 "deaundra" wrote in message ... please help!!!!!!! Column B Column G Barry Y I would like to count how many times these two show together on a row. can this be done? |
#4
|
|||
|
|||
Try...
=SUMPRODUCT(--(B1:B100="Barry"),--(G1:G100="Y")) Hope this helps! In article , "deaundra" wrote: please help!!!!!!! Column B Column G Barry Y I would like to count how many times these two show together on a row. can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formulas | Excel Worksheet Functions | |||
how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) |