Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding 2 days to a day | Excel Discussion (Misc queries) | |||
Adding 28 days to a date | Excel Discussion (Misc queries) | |||
adding days | Excel Discussion (Misc queries) | |||
adding days correctly | Excel Worksheet Functions | |||
Adding days | Excel Discussion (Misc queries) |