Sum cells formatted by conditional formatting

I have an expense worksheet that calculates expenses according to whether they are paid by cash or credit using the respective rates. The way the sheet is set up the cash/credit indicator is bellow the dollar value so it will not work as a SumIf function. I dont want to reformat the sheet if possible. I know that conditional formatted cells can be recognize with a VBA function, but I would rather not make the worksheet that complicated. I am looking for a simpler way, and I think I am either having a mental block or just not looking at this problem the right way.
For some reason I was not able to upload the sample worksheet with my browser. Basically I am looking for a way to sum the values that are cash payments and the values that are credit payments.

Any suggestions would be appreciated.

the formula I used for the conditional formatting is =AND(NOT(ISBLANK(B5)),$B$7="Credit"), and =AND(NOT(ISBLANK(B5)),$B$7="Cash")

SumConditional Example.jpg

What is the rule that formats the cells? Use that as part of your sum formula. If that doesn't make sense, attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window. The paperclip icon does NOT work at present.

Originally Posted by hugowhere

Thank you. I tested this and it also works. thank you for an alternative option then I was thinking of.

It's a bit like using the OFFSET function:

=SUMIF(B7:B17,"Cash",B5:B15) - if the cell two cells below the sum range says "Cash", include that value in the sum.

It's a little trick I keep forgetting about, which is why I'm posting this to try and get it fixed in my head!