Summing based on cell values

markh1182

New Member
Joined
Apr 25, 2006
Messages
48
Hi,
If in column P2, P58, P117, P178 etc have an X in them, how can I use that to sum column N2-N57, P59-P116 etc?
Thanks, Mark
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

markh1182

New Member
Joined
Apr 25, 2006
Messages
48
not quite. I need it to sum from the current X (eg P58) to the previous X (eg P2), and each time it then finds an X, only sum the rows to the previous X. This is to get a sum at the bottom of each page, which is what the X marks.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,673
Messages
5,549,351
Members
410,910
Latest member
DessertDiva
Top