|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 20th, 2010, 08:51 PM
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
March 20th, 2010, 09:16 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
