Sum Range

bayoung

Board Regular
Joined
May 3, 2004
Messages
94
I am trying to write a sumif based on a range. For example, I want to sum anything in column B, providing the data in column A is between 1 to 8. If the date is any other number, then ignore it.

Is this possible?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,317
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top