Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Excel problem

Thread Tools
 
Search this Thread
 
Old Dec 13, 2007 | 11:57 AM
  #1  
GazTheHat's Avatar
GazTheHat
Thread Starter
Scooby Regular
 
Joined: Aug 2005
Posts: 7,638
Likes: 0
From: 392/361 MY04 STi
Default Excel problem

I'm trying to add up every fifth value within a column into a total value. Is there a command/function that i could use to do this?

A
1 £1.50
2 £1.00
3 £2.50
4 £1.00
5 £6.00
6 £2.50
7 £2.50
8 £2.50
9 £2.50
10 £10.00
Reply
Old Dec 13, 2007 | 01:15 PM
  #2  
ChefDude's Avatar
ChefDude
Scooby Regular
 
Joined: Aug 2005
Posts: 4,291
Likes: 0
Default

=IF(INT(ROW(C5)/5)=ROW(C5)/5,C5,"")
Reply
Old Dec 13, 2007 | 03:32 PM
  #3  
GazTheHat's Avatar
GazTheHat
Thread Starter
Scooby Regular
 
Joined: Aug 2005
Posts: 7,638
Likes: 0
From: 392/361 MY04 STi
Default

Thanks.

I managed to get at it using SUMPRODUCT,MOD & ROW.
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
Dec 28, 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
Nov 18, 2015 07:03 AM
leg200
Subaru Parts
5
Oct 7, 2015 07:31 AM
has-scooby
Subaru Parts
4
Oct 6, 2015 03:47 PM
bluebullet29
General Technical
9
Oct 5, 2015 02:17 PM




All times are GMT +1. The time now is 01:25 PM.