# Only calculate everything under 50k

#### leveyc

##### Board Regular
Hi,

I am using the following formula and would like to only sum everything under 50k, any help greatly appreciated

Thanks

=SUMPRODUCT(--('04'!\$J\$2:\$J\$100=A2),--('04'!\$I\$2:\$I\$100))

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

##### Well-known Member
=SUMPRODUCT(--('04'!\$J\$2:\$J\$100=A2),--('04'!\$I\$2:\$I\$100<50000),'04'!\$I\$2:\$I\$100)

are you not using sumifs because of an older Excel version (pre-2007)?

Replies
1
Views
61
Replies
6
Views
118
Replies
7
Views
118
Replies
2
Views
84
Replies
3
Views
44

1,109,400
Messages
5,528,518
Members
409,821
Latest member
decibelpilot

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...