Excel formula
Closed
somu
-
Jan 10, 2010 at 02:22 AM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 13, 2010 at 06:24 AM
tompols Posts 1273 Registration date Wednesday July 28, 2004 Status Contributor Last seen November 25, 2013 - Jan 13, 2010 at 06:24 AM
Hello,
I have a excel data file called BOQ. in which i have around 2000 line items in it. and many are repeating in many areas it is like a furniture supply BOQ, so same type of chair will be repeatedly comming in many location suppose. in 50 locations my chair Ch 2310 is repeatedly coming each time quantity will be different 9 like in room no 1 i have 20 nos of CH2310 and in room no 2 may have 40 and similarly many products.
now what i am doing is i am doing auto filter in the sheet to find out the subtotal of each items but if there is a change in the total quantity i again need to check the same which is not so easy in a big data file like mine.
so what i am looking for a formula whcih will search the model of the item from the column MODEL of my data sheet and give total quantity. in short i will have all the items below to my sheet in a small table format where i will write CH2310 so in quantity column i needs to get the subtotal of the items ( in this case 60 nos)
can any one help me to do so.
I have a excel data file called BOQ. in which i have around 2000 line items in it. and many are repeating in many areas it is like a furniture supply BOQ, so same type of chair will be repeatedly comming in many location suppose. in 50 locations my chair Ch 2310 is repeatedly coming each time quantity will be different 9 like in room no 1 i have 20 nos of CH2310 and in room no 2 may have 40 and similarly many products.
now what i am doing is i am doing auto filter in the sheet to find out the subtotal of each items but if there is a change in the total quantity i again need to check the same which is not so easy in a big data file like mine.
so what i am looking for a formula whcih will search the model of the item from the column MODEL of my data sheet and give total quantity. in short i will have all the items below to my sheet in a small table format where i will write CH2310 so in quantity column i needs to get the subtotal of the items ( in this case 60 nos)
can any one help me to do so.
Related:
- Excel formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
Hi Somu,
It's easier to help you if you give a sample of your data.
I think you are looking for a COUNTIF formula.
Best regards,
Trowa
It's easier to help you if you give a sample of your data.
I think you are looking for a COUNTIF formula.
Best regards,
Trowa
tompols
Posts
1273
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Jan 13, 2010 at 06:24 AM
Jan 13, 2010 at 06:24 AM
Hi,
I think you're looking for =SUMIF() formula
example : https://www.cjoint.com/?bnnyJZ7xwI
I think you're looking for =SUMIF() formula
example : https://www.cjoint.com/?bnnyJZ7xwI