| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count problems
I am trying to count a range of cells based upon their value and another
corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count problems
Hi,
=SUMPRODUCT((A1:A100="A")*(B1:B100="")) Mike "Sqdncall" wrote: I am trying to count a range of cells based upon their value and another corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count problems
Thank you Mike ! Works great!
-- Sqdncall "Mike H" wrote: Hi, =SUMPRODUCT((A1:A100="A")*(B1:B100="")) Mike "Sqdncall" wrote: I am trying to count a range of cells based upon their value and another corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count problems
Hi,
If you are using 2007: =COUNTIFS(A1:A100,"A",B1:B100,"") -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sqdncall" wrote: I am trying to count a range of cells based upon their value and another corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count problems
Hi,
In 2003 or 2007 you can also use this =SUMPRODUCT(--(A1:A8&B1:B8="A")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sqdncall" wrote: I am trying to count a range of cells based upon their value and another corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count problems
Shane,
In 2003 or 2007 you can also use this =SUMPRODUCT(--(A1:A8&B1:B8="A")) No you can't because it doesn't distinguish between columns the OP wanted "A" in column A, this would evaluate true for an A in column B and column A empty Mike "Shane Devenshire" wrote: Hi, In 2003 or 2007 you can also use this =SUMPRODUCT(--(A1:A8&B1:B8="A")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sqdncall" wrote: I am trying to count a range of cells based upon their value and another corresponding cells value. I.E. count A1:A100 for Value "A" and for blank in the corresponding B1:B100 cell. Is this possible? Thank you in advance -- Sqdncall |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if problems | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count problems[Excel 97] | Excel Discussion (Misc queries) | |||
Linear Mode
