Hi All
Am trying to set up a larger spreadsheet as attached. I would like fomulas in Sheet1 b2:c4
which will populate the fields based on the data on sheet 2. eg cell b2, F1 is filtered by DUB so this counts the amount of times DUB apeears on sheet 2 broken down by 1 for FP ABS, twice for ROH EQ and once for ROH SW. Have been playing around with SUMIFS all evening but can't seem to get it right, would appreciate any help
thanks
Noel
Try, for example in B2:
=COUNTIFS(Sheet2!$C:$C,$F$1,Sheet2!$B:$B,$A2,Sheet2!$A:$A,B$1)
Note: You have extra blanks at the end of cells in several areas (e.g. in A2 of Sheet1 and in column C of Sheet2, etc... please take them out or you won't get expected results).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks