Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two colums ? countif
Hi,
I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. [see below] col A col R Week 1 Week 1 20 Week 1 week 2 week 2 How do I say calculate how many charges [col R] occur in "week 1" i.e. no of times there is a value in "col R" for week 1. What would I use if the no. of rows is 250 or if it varies month on month. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
comparing two colums ? countif
Maybe something like this...
=SUMPRODUCT(--(A2:A250="Week 1"),--(R2:R250<"")) If you're using Excel 2007... Assumes the cells in column R are either *EMPTY* or contain a visible entry. =COUNTIFS(A2:A250,"Week 1",R2:R250,"<") -- Biff Microsoft Excel MVP "manfred3" wrote in message ... Hi, I have a spreadsheet with "weeks in column A and "Daily Charges" in column R. [see below] col A col R Week 1 Week 1 20 Week 1 week 2 week 2 How do I say calculate how many charges [col R] occur in "week 1" i.e. no of times there is a value in "col R" for week 1. What would I use if the no. of rows is 250 or if it varies month on month. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif with AND comparing 3 columns | Excel Worksheet Functions | |||
countif comparing two columns | Excel Worksheet Functions | |||
COUNTIF/SUMIF comparing two rows of data | Excel Worksheet Functions | |||
COUNTIF function query for multiple colums | Excel Worksheet Functions | |||
sumif/countif on non-consecutive colums - array? | Excel Worksheet Functions |