RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 788
- Office Version
- 2010
- Platform
- Windows
Any way to do this without a helper column?
Need to countif and sumif the following across two sheets:
Column C which has dates like "01/02/2019" in sheet "JG"
Against the criteria of C1 which is just "Jan" on sheet "Front"
Also in my criteria I'm trying to find value B4 in "Front" against the range "H:H" in "JG"
Have tried Sumproduct but it didn't work very well, any ideas? Obviously I can't do "month(C:C)" otherwise my woes would be over. Thanks!
Need to countif and sumif the following across two sheets:
Column C which has dates like "01/02/2019" in sheet "JG"
Against the criteria of C1 which is just "Jan" on sheet "Front"
Also in my criteria I'm trying to find value B4 in "Front" against the range "H:H" in "JG"
Have tried Sumproduct but it didn't work very well, any ideas? Obviously I can't do "month(C:C)" otherwise my woes would be over. Thanks!