Calling experienced excel users

Things Help
321
322

Do you have the tags (X and Y) there already? You could just use SUMIF if that is the case.

323

You’ll have to read my description above again.
A,B&C are physical factors and X&Y are environmental factors. But that doesn’t really matter.

I just want to know that fastest way to compute the third column.
=SUM(E6:E8)+SUM(E17:E19)+SUM(E25:E27)
=SUM(E10:E12)+SUM(E14:E15)+SUM(E21:E23)

The sheet is pretty big you see.

324

Thanks, I’ll have a look at that.
It’s these little step ups I haven’t used before. I’m not familiar with SUMIF.

325

https://www.extendoffice.com/documents/excel/4970-excel-sum-by-group.html

This is what you want

Anymore help and you’ll be getting an invoice

2 Likes
326

But it’s Saturday…

327

And you are trying to find the total of the xs and ys and are they literally all the same number/word? So they are all either x or y or can they vary

328

Can’t say I fully understand what you’re trying to do but would a SUMIFS + SUMIFS or a SUM(SUMIFS, {X, Y} be what you’re looking for?

329

No, they will never vary.

330

If the numbers are in column C, and X/Ys in column E, then =SUMIF(E:E,“X”,C:C), and then the equivalent formula for Y in another cell.

2 Likes
331

Yeah. I think we all assumed it was a more complicated problem.

1 Like
332

Is the answer not in the last link i provided? Similar to what Jahan said

333

I took a quick look there and I think SUMIF is the answer alright. I just need to work it out.
Groups is probably another complicated step up.

I’ll give it a go some wet dark day. Thanks everybody for the help. I need to cut the hedges and grass now.

2 Likes
334

That’s complicated enough for me. :thinking: :thinking: :thinking:

335

Yea, I think SUMIF is the answer, thanks…

1 Like
336

Like booking a Ryanair flight

1 Like
337

You actually hit the nail on the head there.

Imagine A,B&C are airlines and X&Y are airports. And the integer is lost bags.

So initially I was trying to find out which airline was loosing most bags. But then I wanted to cross check that data with the airports and see if there was any correlation.

338

I think we were all guilty of overestimating @habanerocat here.

He could have just copied the data into a new tab and sorted the table and split it in two it would seem.

1 Like
339

I think I mentioned that I didn’t want to mix up the existing data.

340

You can have the data twice surely, leave what you have alone. Anyway if you can do it Sum if is the neat solution.