| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare the value of one cell to 2 different cells
Hi,
I need some help. I'm trying to do the following without having to count cells then adding them in different work sheets. Please let me know if my explantion is not good. I want to sum up the total number of instances that falls within a date range. For example, if value in the A column is = B1 AND <= B2 then C1 = C1+1 A B C 1 12-1-2008 12-1-2008 2 12-8-2008 12-8-2008 3 10-1-2008 4 12-5-2009 5 12-1-2008 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of one cell to 2 different cells
On Fri, 2 Jan 2009 11:40:01 -0800, NeedExcelHelp
wrote: Hi, I need some help. I'm trying to do the following without having to count cells then adding them in different work sheets. Please let me know if my explantion is not good. I want to sum up the total number of instances that falls within a date range. For example, if value in the A column is = B1 AND <= B2 then C1 = C1+1 A B C 1 12-1-2008 12-1-2008 2 12-8-2008 12-8-2008 3 10-1-2008 4 12-5-2009 5 12-1-2008 Try this formula in cell C1: =SUMPRODUCT((A1:A5=B1)*(A1:A5<=B2)) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of one cell to 2 different cells
Try this:
=SUMPRODUCT(--(A1:A5=B1),--(A1:A5<=B2)) HTH Elkar "NeedExcelHelp" wrote: Hi, I need some help. I'm trying to do the following without having to count cells then adding them in different work sheets. Please let me know if my explantion is not good. I want to sum up the total number of instances that falls within a date range. For example, if value in the A column is = B1 AND <= B2 then C1 = C1+1 A B C 1 12-1-2008 12-1-2008 2 12-8-2008 12-8-2008 3 10-1-2008 4 12-5-2009 5 12-1-2008 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of one cell to 2 different cells
Try this:
=SUMPRODUCT(--(A1:A5=B1),--(A1:A5<=B2)) -- Biff Microsoft Excel MVP "NeedExcelHelp" wrote in message ... Hi, I need some help. I'm trying to do the following without having to count cells then adding them in different work sheets. Please let me know if my explantion is not good. I want to sum up the total number of instances that falls within a date range. For example, if value in the A column is = B1 AND <= B2 then C1 = C1+1 A B C 1 12-1-2008 12-1-2008 2 12-8-2008 12-8-2008 3 10-1-2008 4 12-5-2009 5 12-1-2008 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare the value of one cell to 2 different cells
Hi,
And if your in 2007 you can also use =COUNTIFS(A1:A12,"="&B1,A1:A12,"<="&B2) -- If this helps, please click the Yes button Cheers, Shane Devenshire "NeedExcelHelp" wrote: Hi, I need some help. I'm trying to do the following without having to count cells then adding them in different work sheets. Please let me know if my explantion is not good. I want to sum up the total number of instances that falls within a date range. For example, if value in the A column is = B1 AND <= B2 then C1 = C1+1 A B C 1 12-1-2008 12-1-2008 2 12-8-2008 12-8-2008 3 10-1-2008 4 12-5-2009 5 12-1-2008 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two cells, if equal move a third cell to another cell | Excel Discussion (Misc queries) | |||
| Compare a cell to a range of cells? | Excel Discussion (Misc queries) | |||
| Compare two Cells and highlight third cell | Excel Worksheet Functions | |||
| Compare two cells and return certain value in third cell | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
Linear Mode
