Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUM(IF help please
I'm helping my husband do a spreadsheet for work, and last time I had a
question I came here and I got much needed help but that was a while ago and now I'm back. <:O) He works with lieterally hundreds of warehouses and the salesmen need to be able to see at a glance at what warehouse the product is in. Usually they have a potential customer on the phone and need quick answers. I have set up a page that referances ALL the warehouse pages. Each warehouse has their own page....... This is what I have =SUM(IF(Barrett!$E$12:$E$574=$B$4,IF(Barrett!$G$12 :$G$574=$B$5,IF(Barrett!$H$12:$H$574=$B$6,IF(Barre tt!$A$12:$A$574,1,0))))) Whe b4 = type of material b5 = dimension of material b6 = thickness of material At first the salesmn were ok with it meeting ALL the criteria, it would "pop up" but in addition to that, they want to be able to do like a "quick search" and be able to just enter in 1 of the criteria instead of HAVING to put in all 3....... They still want to utilize all 3 for when they need the specifics, but say for example they need a certain type of material but dimension and thickness doesn't matter... Right now they still need to put that info in for it to pick up the warehouse. They want to be able to put in all 3 if they wanted or just 1..... Or say for instance they wanted 4x4 material but the other 2 criteria didn't matter........ How would I go about doing this??? I have NO IDEA how I would do this so any help you can give will be greatly appreciated. Krista |