Evening,
I am using this formula:
=SUMPRODUCT(('KS4 RESULT INPUT SHEET'!$X$2:$X$245=$A5)*('KS4 RESULT INPUT SHEET'!$AC$2:$AC$245=D$3))
However I need to amend the end, instead of checking to see if the value of D3 is present, I need to change it to checking if the following values are present F+ or F or F-
I would greatly appreciate any help you can give.
Regards
Hi CMorgan,
Please see attached for one possible solution. Substitute the second part of your formula with the formula in red highlighted cell.
Hope this helps!
sumproduct.xlsx
Regards,
jeversf
With SUMPRODUCT
with COUNTIFS
=SUMPRODUCT(('KS4 RESULT INPUT SHEET'!$X$2:$X$245=$A5)*('KS4 RESULT INPUT SHEET'!$AC$2:$AC$245={"F","F+","F-"}))
=SUM(COUNTIFS('KS4 RESULT INPUT SHEET'!$X$2:$X$245,$A5,'KS4 RESULT INPUT SHEET'!$AC$2:$AC$245,{"F","F+","F-"}))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks