Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm trying to set it up so that all figures which match the same two criteria are all added up together, using only one formula. Both criteria are based on Text - for instance "English", and "September" So far I've got this for both, but can't work out how to combine them both. =SUMIF(A:A,"English",G:G) & =SUMIF(B:B,"September",G:G) Is there any way of getting it so that the overall sum of all entries matching both criteria is shown? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
Search 2 Criteria for 1 sep result | Excel Discussion (Misc queries) | |||
Result Based on Date Criteria | Excel Discussion (Misc queries) | |||
how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions |