ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sum of data where a condition applies (https://www.excelbanter.com/excel-discussion-misc-queries/135559-sum-data-where-condition-applies.html)

kippers

Sum of data where a condition applies
 
Hi,

Can someone advise me on the easiest way to apply basic functions (MAX) etc.
to a range of data but only where a set condition applies (i.e. effectively
want to perform a MAXIF function but I don't believe this exists).

Basically I have a years worth of data (2 days of which are shown below)
and I want to calculate the maximum number of calls for each day over the
yearly period. As a result I want to have 1 figure for each day of the week
and this figure should represent the maximum number that was found for that
particular day.

A B
1 Day of Week Number of Calls
2 Monday 2
3 Tuesday 1
4 Wednesday 4
5 Thursday 8
6 Friday 7
7 Saturday 4
8 Sunday 6
9 Monday 8
10 Tuesday 4
11 Wednesday 9
12 Thursday 7
13 Friday 4
14 Saturday 7
15 Sunday 9

I'm not necessarily after a formula.... just the easiest way of doing this
in Excel for another 363 days worth of data!!

Any help gratefully appreciated

Cheers,

Gary''s Student

Sum of data where a condition applies
 
Look into using a Pivot Table. It can give you a variety of stats organized
by catagories.

See:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student
gsnu200711



All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com