Hi...I can't seem to use the SUMIF function to calculate a criteria. Despite thorough checks through the formula, the function keeps returning zero for the answer. I am using two linked spreadsheets. One is for the data and the other is for the report. In the data spreadsheet, A1:A5 for example have several data like buyer, order quantity...While B1:B5 have the necessary inputs. I tried to use the formula SUMIF to calulate Order Quantity in the report spreadsheet to no avail. The Formula is I'm using is something like this SUMIF(A1:A5;=Order Quantity;B1:B5). Can anybody help? Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SUMIF
- Thread starter lkjing
- Start date
Fergus
Well-known Member
- Joined
- Mar 10, 2004
- Messages
- 1,174
OK, now it's 11.30pm here now, which means it's half past midnight down there in Singapore so I'm knocking off. If you have any more problems with it I'll look tomorrow morning, unless of course someone else has already answered. Goodnight.
Upvote
0
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).
