sumif does not work if as intended

semidevil

New Member
Joined
Jul 9, 2007
Messages
35
Can anyone explain how to solve this issue with my sumif formula.

Cells A1 has a value of 100/300, and cell B1 has a value of 30.
Cells A2 has a value of " > 100/300" (without the quotes), and B2 has a value of 20

if I do a sumif and search for 100/300, I return 30 as expected. However, if I do a sumif and search "> 100/300" (without quotes), I get a value of 50. why is it not returning 20?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,095,481
Messages
5,444,736
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top