Forum Discussion

Copper Contributor

Sep 26, 2024

Help with SUMIF for good karma

The below formula isn't working and I think it's because the last argument is a range. Can anyone help me find a solution that will work please? =SUM(('2024'!$S$2:$CH$255)*(--('2024'!$H$2:$H$255...

Formulas and Functions

Gold Contributor

Sep 27, 2024

It's kinda hard to help you without seeing what the formula is working with (i.e., seeing the cells to which it refers). Your hypothesis is a reasonable one. Why don't you proceed by testing that hypothesis? i.e., by making the last argument something other than a range. But you'd help us help you by posting a copy of the spreadsheet itself, not just the formula that somehow is failing to work as desired.

SimoneC2220
Copper Contributor
Sep 27, 2024
mathetes I appreciate your patience. I should have thought of that. I'm trying to do a few things. Datasheet is 2024. In the Mappings tab, I'm try to sum the cells with numeric values (2024 s2:ch255) based on multiple criteria. first is 2024, column h value, then columns s1:ch1 but instead of using individual columns when referencing values I need in 2024, I'd like to use a range in Mappings tab. For example, I would like sum of all cells in 2024 columns s1:ch255 where 2024 column h = "cd" and range s1:ch1 match Mappings tab b37:b50. Result to appear in Mappings e17.

File sent via Messages.
- Harun24HR
  Bronze Contributor
  Sep 27, 2024
  It would be better if you share a sample here in post/comment via one-drive or google-drive so that other contributor can also put formula for you.
  - SimoneC2220
    Copper Contributor
    Sep 27, 2024
    Harun24HR hi there! Thank you for responding. I appreciate all the guidance.
    
    https://docs.google.com/spreadsheets/d/18YO5ctgJeCn_hX4S1St7VkKfOEWxwUY6/edit?usp=drivesdk&ouid=110855865394613237794&rtpof=true&sd=true

Resources