SUMIF Not Working (Validation List & Delimiting values)

[leschkeb]

Hi there, I have a sheet where i enter the description of an invoice (column A) - and then split the desctription into columns b,c,d. I do this for 3 tables. I then use a validation list to categories the transactions and need to be able to calculate the total of each category across each table - resulting in a single total for each category where a value has been entered. I am not having much luck; any advice? I am relatively new to this. Best. Benjamin

 

[BigBeachBananas]

If I understand your question correctly,

=LET(x,TOCOL(C2:C37,3),SUM(FILTER(x,ISNUMBER(x))))

 

[leschkeb]

If I understand your question correctly,

=LET(x,TOCOL(C2:C37,3),SUM(FILTER(x,ISNUMBER(x))))

Thanks, I am not sure what to do with that sorry. I wasn't sure if i could upload a sample of the sheet itself, just signed up today.

 

[BigBeachBananas]

Thanks, I am not sure what to do with that sorry. I wasn't sure if i could upload a sample of the sheet itself, just signed up today.

You can upload a minisheet using the XL2BB tool.

Try copy that formula and paste it in 1 of the cell and see it returns your desired result.

 

[Scott Huish]

If the above answer works, then so should this:
=SUM(TOCOL(C2:C37,3))