Sigvaldason
New member
- Joined
- Aug 23, 2011
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi,
I'm having a problem on how to use the SUMIF calculation correct.
My problem is:
I want to show the top5 biggest deviations between two numbers.
This is quite easily and can be done by this formula:
=SUM(LARGE(Inputs!H:H;{1}))
What i then want to do, is to dinstinguish the deviations according to the actual week.
If i have a coloumn with weeks, a column with eg. input, one with output, and one with output.
How can i then use the SUMIF function to summarize the top 5 deviations in the actual week?
Can anybody help?
- Sigvaldaon
I'm having a problem on how to use the SUMIF calculation correct.
My problem is:
I want to show the top5 biggest deviations between two numbers.
This is quite easily and can be done by this formula:
=SUM(LARGE(Inputs!H:H;{1}))
What i then want to do, is to dinstinguish the deviations according to the actual week.
If i have a coloumn with weeks, a column with eg. input, one with output, and one with output.
How can i then use the SUMIF function to summarize the top 5 deviations in the actual week?
Can anybody help?
- Sigvaldaon