Thread: Adding Days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toast Toast is offline
external usenet poster
 
Posts: 2
Default Adding Days

Column A has dates, and column B has sales figures for the respective dates.

I'm trying to use =SUMIF to add together all the "Mondays" and the rest of
the days of the week, and =COUNTIF to count the number of "Mondays" so that I
can get a value that tells me how much each day's average is approximately.
I've gotten this far, then got stuck because I have no idea what to do:

=SUMIF(A2:A200,"Monday",B2:B200)

Your help's appreciated ahead of time :)