Adding data in a row based on criteria from another

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
I am trying to add data in one range based on criteria from another. For example, I would like to add all data in Row 2 where Row 1 is less than or equal to 3

A B C D E
Row 1- 0 1 2 3 4
Row 2- 1 1 1 1 1

So, A2+B2+C2+D2 but not E2

I cannot seem to figure out how to do this. Can anybody help me out, please.
-Mike[/i]
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Pekkavee

Well-known Member
Joined
May 25, 2004
Messages
1,218
Maybe I didn't fully understand what you want but try something like this

=IF(A1>3,"Bigger than 3",SUM(A1:A2))

Pekka
:eek: :eek:
 

Pugs107

New Member
Joined
Nov 18, 2005
Messages
19
Sorry, that example looked terrible.
Book1
ABCDE
112345
212122
Sheet1


I need to create a formula that will lookup the values in Row2 that correspond to values in Row1 that are less than 3 and find the sum of them.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,269
Messages
5,577,108
Members
412,768
Latest member
klig
Top