| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Summing some cells
In cell E1 I will type in Yes or No.
In D1 I would like to count the number of cells that have data in B1:B10, but only when the Yes or No that is listed in C1:C10 is matched Thanks for the help |
|
#2
|
|||
|
|||
|
Try this:
=SUMPRODUCT(--(C1:C10=E1),--(B1:B10<"")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jim" wrote in message ... In cell E1 I will type in Yes or No. In D1 I would like to count the number of cells that have data in B1:B10, but only when the Yes or No that is listed in C1:C10 is matched Thanks for the help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help adding text values | Excel Worksheet Functions | |||
| Summing non consecutive cells | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| summing part of cells in a range | Excel Discussion (Misc queries) | |||
| Summing cells in Excel | Excel Worksheet Functions | |||
Hybrid Mode
