# Summing columns to matched symbol/letter for expense form

1. ## Summing columns to matched symbol/letter for expense form

This is a manual expence form that i need to automate.

I'm relatively new to excel and cant seem to grasp the format used when doing multiple criteria, i also want to keep the form as neat as possible and don't want 00.00 in the formula box if there is no value, although i could use conditional formatting, if needed, any help and advice gratefully received.

In columns E and F shows cash receipted
In columns G and H shows cash no receipt
In columns I and J shows credit card purchases

I need to calculate each section relavent to the curency being used at the time (we travel all over the world so i need to match what is in C29 to C33 rather than give actual symbols)

So all £, \$, €, K, B would need to be calculated individually and put in there relavent row in K29 to K33, then the diference between Used K29 to K33 and Available would be in, Remaining L29 to L33.

The main thing is i need whatever symbol/letter i put in C29 to C33 to be variable due to contries traveled

Expence Form.xlsx

2. ## Re: Summing columns to matched symbol/letter for expense form

One way of summing the values for each currency symbol:

K29: =SUMIF(\$F\$5:\$F\$25,\$C29,\$E\$5:\$E\$25)+SUMIF(\$H\$5:\$H\$25,\$C29,\$G\$5:\$G\$25)+SUMIF(\$J\$5:\$J\$25,\$C29,\$I\$5:\$I\$25)

Regards, TMS

3. ## Re: Summing columns to matched symbol/letter for expense form

TMShucks

Thanks for that, works perfect, I understand now how it works, I'll spend some time tonight trying to write it for myself from scratch.

4. ## Re: Summing columns to matched symbol/letter for expense form

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1