IF function

  • Thread starter Thread starter gregg
  • Start date Start date
G

gregg

I have a problem with IF function. The problem is column
4 has only 2002 entries, column 5 has 2002 and 2003
entries. If column 5 only had 2002 entries then a count
by month would suffice. If a cell in column 5 is null
then count by the cell in column 4. If column 5 has an
entry then count the cell in column 5. I now need an IF
statement that checks for year and counts by month for
year 2002 and a separate count by month for 2003.

this is the IF statement currently used.
=IF(ISBLANK(K5),"0",MONTH(K5))

thanks in advance.
 
In adjacent columns add the formulas =YEAR(column 5 cell) and =MONTH
(column 5 cell). Copy this down to cover all the rows with data in
column 5. Add column headers for column 5 and the adjacent columns.
Now, create a PT based with the YEAR and MONTH columns as row fields
and the column 5 dates as the data field. Ensure that the data field
is summarized with the Count function, not the Sum function.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top