Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sum multiple columns counting including blanks and dates
I have two columns of which I want to use as criteria to add contents of a
third column. The columns may or may not be blank and one of the columns if complete should only be counted if date less than 7/1/2005 for example. I would like to sum and also count this data. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sum multiple columns counting including blanks and dates
=SUMPRODUCT(--(A2:A20<=--"2005-07-01"),--(B2:B20="criteria"),C2:C20)
should do it, replace criteria with your secondary test value -- HTH RP (remove nothere from the email address if mailing direct) "BK99" wrote in message ... I have two columns of which I want to use as criteria to add contents of a third column. The columns may or may not be blank and one of the columns if complete should only be counted if date less than 7/1/2005 for example. I would like to sum and also count this data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates including the beginning date. | Excel Worksheet Functions | |||
Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
Multiple sets of columns into one set of columns no blanks | Excel Discussion (Misc queries) | |||
Counting Blanks in a list of dates by month | Excel Worksheet Functions | |||
Counting rows of blanks across certain columns | New Users to Excel |