I think I understand what you're trying to do and I would use an array formula. Try this:
=Count(if('metals L2'!E2:E1132="*sigma*",if('metals L2'!A2:A1132="D1",0)))
To make this an array hold down Ctrl & Shift and then Enter. The formula won't work if you just enter...
Hi
I was going to suggest a pivot table but didn't b'cos I didn't think you could automatically re-set your pivot data when you added new details to the source data. I know you refresh to update but what if you regularly add to the source (more rows) ??. Wouldn't you have to go back to step 3 of...
Try this
Cell A1 5/12/99
Cell B1 =YEAR(A1). This will return only the year
Cell C1 The value you have attributed to that particular date. Eg 2
Cell A2 20/12/99
Cell B2 =YEAR(A2).
Cell C2 Applicable value. Eg 10
Then, wherever you want to return the results for each year use the SUMIF...
I am wanting to ensure that specific data is entered into specific fields on specific occasions.
Eg
If Cell A1 entry is "Regal" then cell B1 MUST be either BBB or CCC. Nothing else and it can not be left blank. Any simple ideas ?.
Thanks. I'm having a bad day !
Hi
I have a spreadsheet that is used to capture data on a daily basis, month on month. The data, once captured is then sent out to various parties. Each party has a requirement to see different columns.
The user makes considerable use of the Grouping/Outline functions as each record can have 5...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.