Search results

Hui, Thanks a lot, it works well, as usual your solutions are great. Thanks again.

oldchippy, Thanks for response, I think my question is not properly explained, what I want to know if sumifs formula allows to set two sum ranges or not, it does not matter the required sum ranges are in the same worksheet or the different. Hope this make sense now, thanks.

Hello everyone, I have a question, is it possible to set two sum ranges from two different worksheets in sumifs formula? Any help is highly appreciated. Thanks in advance.

Twee With the Tables feature in Excel 2007 and above you can do that. Convert your data into table then you can use column heading in any of your formula. The format is like this: =COUNTIF([ColumnHeading],Criteria) if within same table =COUNTIF(TableNumber[ColumnHeading],Criteria) in other...

Another request for help, hope the below example is clear to understand and makes sense. Thanks in advance. Sheet1 Column-A Column-B 1 (Using formula: =COUNTIF($B$2:B2,B2) B-001 1 B-002 2 B-001 1...

Thanks a lot oldchippy.

What formula can I use to get the result in column A, as shown below: Col-A Col-B 1 B-001 if it is unique 2 B-001 if it is repeated 1 B-003 if it is unique 2 B-003 if it is repeated 3 B-003 if repeated again Thanks in advance.

Thanks a million Hui:)

Hui, Thanks a lot, it works well but i want to count the entries of columnC (Sheet1) if the data of columnA (Sheet1) match with cell A1 (Sheet2). Your suggested formula is fine too and giving the desired result, but out of curiousity elaborating to see if columnC can be counted. Thanks, Razaas

Any help will be highly appreciate, I want to count the number of entries in column-C of sheet1 if the data in column-A of sheet1match with data of cell A1 of sheet2 Example: SHEET1 Col-A Col-B Col-C Col-D B-001 1234 12-May-09 Need formula to get the desired result B-002 3241...

Hi all, I am Syed from Kuwait, joining this blog I expect a lot of excel learning opportunities, I admire Chandoo's abilities and sense of humor. I can see many excel experts are members of this blog so with above basic level excel knowledge I can imagine how much here for me to learn...